One of our clients is a long-time on-premise Oracle EBS customer.
They implemented Oracle Unifier cloud few months back. They
were looking for an effective solution to load actuals transactions from on-premise
Oracle EBS to Oracle Unifier cloud. They had created business process in Oracle Unifier for actuals transaction and enabled for integration.
They had one simple requirement. They need a scalable
solution to load eligible actuals transaction from on-premise Oracle EBS to
Oracle Unifier cloud daily using rest API.
Digging deeper we could identify few more
things to be taken care
- Ability to introduce new attribute 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
- Utilize Oracle EBS concurrent request to populate data daily in a staging table.
- Pull data from Oracle Unifier cloud in staging table.
- Compare the data in two staging tables to identify new and modified data.
- Call Oracle Unifier Rest API to process the data.
1.
Advantage 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.
