Project Partners Blog


Customer Solution Success! Oracle E-Business Suite and Oracle Unifier Integration Framework

Project Partners Blog Author:
Sachin Gupta | Oracle Primavera Solution Architect – Application Integration Specialist

Oracle E-Business Suite and Oracle Unifier Integration Framework

Project Partners implemented this solution for a large metropolitan transportation, and on-premise Oracle EBS customer.

The project consisted of the customer implementing Oracle Unifier cloud a few months prior. They were looking for an effective solution to load actuals transactions from on-premise Oracle EBS to Oracle Unifier cloud. They had created a business process in Oracle Unifier for actuals transaction and enabled for integration.

The customer did have one simple requirement. They needed a scalable solution to load eligible actuals transaction from on-premise Oracle EBS to Oracle Unifier cloud daily using a REST API.

As the project moved forward, we conducted our due diligence and dug deeper so we could identify a few more items that needed to be appropriately addressed:

  • Ability to introduce new attributes in the integration equilibrium which may require updating all transactions in Unifier with the data from EBS.
  • Avoid duplicate transactions.
  • Capable to identifying and create/update transactions and in rare scenario delete transactions from Unifier to keep it always in sync with Oracle EBS.

After reviewing various options with customer, they agreed on the framework shown below:

  1. Utilize Oracle EBS concurrent request to populate data daily in a staging table.
  2. Pull data from Oracle Unifier cloud in staging table.
  3. Compare the data in two staging tables to identify new and modified data.
  4. Call Oracle Unifier Rest API to process the data.

Noted advantages of this framework:

  • Scalable – It can easily process a volume of 100,000 transactions daily.
  • Automated – It can identify new vs modified data and discard data that do not require change.
  • Extensible – New attributes introduced for integration, can be easily populated for all existing transactions in Oracle Unifier Cloud.

Project Partners, a long-standing Oracle Partner, and global leader in optimizing business processes and IT investments within project-driven organizations.

www.projectp.com