Before You Install the Recipe

You must perform the following configuration tasks on your Oracle ERP Cloud, Apache Kafka, and Oracle Autonomous Transaction Processing instances in order to successfully connect to these external systems using Oracle Integration and achieve synchronization.

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud (or Oracle Procurement Cloud) instance from Oracle Integration, you'll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.

  1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You'll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.
  2. Assign the following roles/privileges to the user account. See Assign Required Roles to an Integration User in Using the Oracle ERP Cloud Adapter with Oracle Integration 3.
    • Integration Specialist
    • AttachmentsUser
    • FND_MANAGE_CATALOG_SERVICE_PRIV
    • ASM_IMPLEMENTATION_MANAGER_DUTY
  3. Enable supplier events.

    To get the required supplier data updates from Oracle Procurement Cloud, you need to subscribe to supplier Create/Update events in Oracle ERP Cloud. The Supplier Create/Update events include the Supplier Number and SupplierID attributes in the output payload. Oracle Integration uses the event attributes to invoke the Supplier REST API and get the required supplier data updates from Oracle Procurement Cloud.

    1. Log in to your Oracle ERP Cloud instance.
    2. Click My Enterprise from the navigator on the home page, and then click Feature Updates.
    3. In the Features Overview page, select the Available Features tab.
    4. Enter Suppliers in the functional area search field.

      All available features that belong to the suppliers functional area get listed.

    5. In the row for the feature Enabled Outbound Supplier Profile Integration Using Oracle Cloud, click Enabled.
    6. In the resulting window, select the Enable check box for the feature Enable Outbound Supplier Profile Integration Using Oracle Cloud.
    7. Click Done.

Configure Apache Kafka

Complete certain configuration tasks to successfully connect to Apache Kafka from Oracle Integration and achieve synchronization.

  1. Get the Apache Kafka Cluster Bootstrap Server URL. See Prerequisites for Creating a Connection in Using the Apache Kafka Adapter with Oracle Integration 3.
  2. Install the connectivity agent.

    As Apache Kafka is hosted on-premise and is behind a firewall, you must install and configure the connectivity agent to allow Apache Kafka to interact with applications in the cloud.

    Before you install the connectivity agent, review the following:
    To install and configure the connectivity agent:
    1. Create an agent group.
    2. Download and install the connectivity agent.
  3. Configure an Apache Kafka topic.
    1. From the command prompt execute the following command to create a topic named supplier_topic:
      kafka-topics.bat --zookeeper 127.0.0.1:2181 --topic supplier_topic --create –partitions 3 --replication-factor 1

      You get a message that the topic is created.

    2. To view the topic you just created, execute the following command:
      kafka-topics.bat --zookeeper 127.0.0.1:2181 –list

      A list of topics, including the supplier_topic that you created, is displayed.

Configure Oracle Autonomous Transaction Processing

Complete the following configuration tasks on your Oracle Autonomous Transaction Processing instance.

The following steps give an overview of the tasks you need to perform in order to create a connection from Oracle Integration to Oracle Autonomous Transaction Processing. For detail information, see Prerequisites for Creating a Connection in Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration 3.

  1. Download the client credentials wallet.

    This is a zip file containing the client security credentials. By default the file name is Wallet_<databasename>.zip. You can save this file as any file name you want.

  2. Get the database service name.

    Note that the service name must be same as the one in the tnsnames.ora file in the client credential wallet.

  3. Get the wallet password.

    You'll be prompted to enter a wallet password while downloading the client credentials wallet. Note the password as you'll need it while configuring the Oracle Autonomous Transaction Processing connection security from Oracle Integration.

In addition to the above configuration tasks, you need to set up a database table in your Oracle Autonomous Transaction Processing instance to synchronize supplier information.

Create an ATP database table

  1. Log in to your Oracle Autonomous Transaction Processing instance.
  2. Navigate to the Service console, and in the left Autonomous Transaction Processing navigation menu, click Development.
  3. Click Database Actions.
  4. In the Database Actions page, under the Development section, click SQL.
  5. Using data definition language define and create your database object - a database table named v_Supplier - and specify the fields as shown in the table below.
    Field Name Data Type Not Null Primary Key
    v_SupplierId number Yes Yes
    v_SupplierName varchar2(20) - -
    v_SupplierNumber number - -
    v_BusinessRelationship varchar2(20) - -
    v_Status varchar2(20) - -
    v_DUNSNumber int - -
    v_TaxRegistrationNumber varchar2(20) - -
    v_TaxpayerId varchar2(20) - -
    v_TaxpayerCountryCode varchar2(20) - -
    v_SupplierTypeCode varchar2(20) - -
    v_TaxOrganizationType varchar2(20) - -