Oracle Primavera Unifier Report Extraction with Oracle Integration Cloud (OIC)

We designed and implemented an integration solution between Oracle Primavera Unifier and Oracle Fusion Applications using Oracle Integration Cloud (OIC), enabling the automated extraction of User Defined Report (UDR) data through scheduled processes and its seamless delivery to Fusion Applications.

Oracle Primavera Unifier serves as the source system, where User-Defined Reports are generated based on business process data and user-defined parameters.

Oracle Integration Cloud (OIC) acts as the integration layer, orchestrating the data flow, applying transformations and facilitating secure and seamless connectivity between Unifier and Oracle Fusion Applications.

Oracle Fusion Applications is the destination where the processed report data is delivered. This enables further business processing, reporting, or financial analysis within the Fusion ecosystem.

Reports Integrated and Corresponding Fusion Modules

UDR Type	Fusion Module	Submodule / Use Case
Budget	Oracle Fusion Financials / PPM	Budgetary Control, Project Costing
Invoice	Oracle Fusion Financials	Accounts Payable (AP)
Purchase Order	Oracle Fusion Procurement	Purchasing
Purchase Order Acknowledgements	Oracle Fusion Procurement	Supplier Portal, PO Acknowledgement
Change Orders	Oracle Fusion Project Portfolio Management (PPM)	Project Costing, Contract Adjustments
Contracts	Oracle Fusion PPM / Fusion Contracts	Project Contracts, Enterprise Contract Management

This integration enables stakeholders to maintain consistent, real-time data between Unifier and Fusion systems, reducing manual intervention and ensuring data accuracy across financial and project domains.