Opportunity
California eProcure #20A0408
Caltrans turnkey ad hoc reporting solution with 44 standard financial and project reports
Posted
November 20, 2026
Respond By
January 22, 2027
Identifier
20A0408
Caltrans is seeking a turnkey financial ad hoc reporting solution for its statewide operations. - Buyer: California Department of Transportation (Caltrans), State of California; Division of Procurement and Contracts (DPAC). - Requested solution: One ad hoc reporting solution for at least 2,000 users, installed in Caltrans’s managed environment at the State Data Center. No reporting-solution OEM, product name, or part number is specified. - Reports and services: Develop 44 standard financial and project reports; provide implementation, integration, testing, training and knowledge transfer, maintenance, and operations. Create a semantic/presentation layer for Caltrans’s Financial Data Model. - Data and platform context: The Financial Data Model is in Oracle Autonomous Data Warehouse on Oracle Cloud Infrastructure and supports data from FI$Cal and legacy sources. Oracle is identified as the maker of this underlying data platform, not as the specified OEM of the requested reporting solution. - Notable requirements: Support SQL-based report and query building, scheduling, visualizations and exports, role-based access and Caltrans single sign-on, and data availability by 6 a.m. daily. The solution must address security, privacy, monitoring, recovery, documentation, and vendor support requirements; stated targets include 99% availability, a 72-hour recovery time objective, and a 24-hour recovery point objective. Acceptance includes a 30-day stable production period. - Training: Cover beginner, intermediate, and advanced users. Requirements include in-person training for 75–100 advanced users/SMEs, at least 10 virtual beginner/intermediate sessions, and at least 20 virtual open sessions, with guides, job aids, a practice sandbox, and knowledge transfer. - Term: The documents describe 15 months for implementation followed by 9 or 12 months of maintenance and operations; the maintenance duration differs across documents. An optional Year 3 is also referenced.
Description
The California Department of Transportation is seeking a turnkey Ad Hoc Reporting Solution installed, integrated, accepted, and maintained in its Caltrans-managed environment, hosted at the State Data Center. The solution will enable non-technical staff to create custom financial reports without programming and must support 2,000 users. The scope includes implementation, maintenance and operations, training, and 44 standard reports. The solicitation requests fixed-price, deliverable-based proposals.