Nick Woodrow |

CEMAR and Oracle Integration

We are 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 users of the CEMAR software as a standard offering, whilst working with clients to build further integrations for periodic release.

Our contract management tool CEMAR 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 the CEMAR platform 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 the CEMAR system 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