Synchronize Supplier Updates Between Oracle Procurement Cloud and Oracle ATP
Use this recipe to synchronize supplier updates between Oracle Procurement Cloud and Oracle Autonomous Transaction Processing (ATP) database.
Note:
This recipe is available as Oracle Procurement Cloud — Oracle ATP | Synchronize Supplier Updates in the Integration Store. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.
Overview
This recipe updates the Oracle 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. 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 Oracle ATP database table. The integrations use app-driven orchestration, and the standard Oracle ERP Cloud Adapter, Apache Kafka Adapter, and Oracle Autonomous Transaction Processing Adapter.
To use the recipe, you must install the recipe package and configure the connections and other resources within the package. Subsequently, you can activate the integrations. 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 Oracle 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 ATP
- Apache Kafka
- An account in Oracle ERP Cloud with the Administrator and Procurement Manager roles
- An account in Apache Kafka with the Administrator role
- An account in Oracle ATP with the Administrator role
- An Oracle 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 Oracle ATP database table.
