Nick Woodrow | 14 Mar 2019

CEMAR and Oracle Integration

CEMAR is building a library of APIs built upon client requirements and linking our system with common third-party applications in standard use across the construction and engineering industry such as; Oracle Fusion & Primavera, Salesforce, SAP and other ERP systems. In time we plan to launch a public API library to deliver these web services to all CEMAR users as a standard offering, whilst working with clients to build further integrations for periodic release.

The CEMAR system is effective as a stand-alone contract management solution, however we recognise that in some deployments, as part of a collective solution, data must be transferred between systems to support transparency, governance and reporting on major infrastructure projects.

Our client planned to deploy Oracle Fusion for enterprise resource planning (ERP) and required contract values and payment data to pass from the CEMAR system to Oracle Fusion for purchase order values and managing payment transactions. On completion of those financial transactions a flag was required to pass back into CEMAR to show those payments as having been made.

By linking CEMAR and Oracle Fusion using an API we successfully delivered data relating to all contract value updates in CEMAR, as a result of compensation events, and payment data for completing financial transactions.

Where compensation events had been implemented through the acceptance of a quotation project manager assessment this change to the Prices was recorded in both CEMAR and passed to Oracle Fusion to manage the total value of the contract within the ERP system.

Certified payment assessments resulted in data being passed to Oracle Fusion in order to allow payment to be made in the financial transaction system with confirmation of payment received back into CEMAR and flagged against the relevant contract and specific payment assessment.

An integral part of the process was the collaboration between both system owners and the client to establish a clear and concise set of requirements that could be realised in an API.


Back to Blogs

Latest Blogs

Blog | 14 Mar 2019

CEMAR and Salesforce Integration

By Nick Woodrow
Blog | 09 Mar 2018

CEMAR Key Features

By Nick Woodrow
Blog | 16 Feb 2018

CEMAR – the contract’s digital twin

By Nick Woodrow
Blog | 12 Dec 2017

What keep it simple means….

By Nick Woodrow
Blog | 19 Oct 2017

Are you using digital in an analogue way – what would Henry Ford think?

By Nick Woodrow