About This Recipe
This recipe updates the Oracle Autonomous Transaction Processing (ATP) database in real time when supplier data (for example, products and services, transaction taxes, payments, addresses, sites, contacts) is updated in Oracle Procurement Cloud.
To use the recipe, you must install the recipe and configure the connections and other resources within it. The recipe contains two integration flows, one for receiving the supplier data updates from Oracle Procurement Cloud and then updating the same into an Apache Kafka topic, and another for writing the supplier data updates from the Apache Kafka topic into the ATP database table. When supplier data is updated in Oracle Procurement Cloud, the first integration (Oracle ERP Kafka Supplier Sync Producer) is triggered. The integration flow receives the updates from Oracle Procurement Cloud and writes the updates into an Apache Kafka topic. This in turn triggers the second integration (Oracle Kafka ATP Supplier Sync Consumer) which consumes the updates from the Apache Kafka topic and writes the updates to the ATP database table, thereby synchronizing the supplier data updates between the systems.
System and Access Requirements
-
Oracle Integration, Version 21.2.2.0.0 (210505.1400.40944)
-
Oracle ERP Cloud
-
Oracle Autonomous Transaction Processing
-
Apache Kafka
-
An account on Oracle ERP Cloud with the Administrator and Procurement Manager roles
-
An account on Apache Kafka with the Administrator role
-
An account in Oracle Autonomous Transaction Processing with the Administrator role
-
An ATP database table with write access
Recipe Schema
This section provides an architectural overview of the recipe.
An event is raised in Oracle ERP Cloud (Oracle Procurement Cloud) when supplier data is updated. This triggers the first integration flow in Oracle Integration. The integration flow uses the Oracle ERP Cloud Adapter and the Apache Kafka Adapter (Producer) to get and write the updates to an Apache Kafka topic. This in turn triggers the second integration flow which uses the Apache Kafka Adapter (Consumer) and Oracle Autonomous Transaction Processing Adapter to write the supplier data updates from the Apache Kafka topic to an ATP database table.
