Install and Configure the Recipe

On your Oracle Integration instance, install the recipe package to deploy and configure the integration and associated resources.

  1. On the Oracle Integration home page, scroll to the Accelerators & Recipes section.
  2. Click Search All.
  3. Find the recipe package that you want to install.
  4. Select the package, and then click the Install Install icon icon.
  5. After the package is installed, click the Configure Configure icon icon on the recipe card to configure the resources deployed by the package.

    The Configuration Editor page opens, displaying all the resources of the recipe package. Configure the following resources before you activate and run the recipe.

Configure the Oracle ERP Cloud Connection

  1. On the Configuration Editor page, select Oracle ERP Cloud Connection.
  2. Click Edit Edit icon.
    The connection configuration page appears.
  3. In the Connection Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  4. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on Oracle ERP Cloud. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on Oracle ERP Cloud.
  5. Click Save. If prompted, click Save for a second time.
  6. Click Test to ensure that your connection is successfully configured.
    A confirmation message is displayed if your test is successful.
  7. Click Back Back icon to return to the Configuration Editor page. Click Save again if prompted.

Configure the Oracle Apache Kafka Connection

  1. On the Configuration Editor page, select Oracle Apache Kafka Connection.
  2. Click Edit Edit icon.
    The Oracle Apache Kafka Connection window appears.
  3. In the Bootstrap Servers field, enter the Bootstrap Server URL you obtained earlier while configuring Apache Kafka.
  4. In the Security Policy field, select No Security Policy.
  5. Select the agent group under the Agent Group section.
    1. Click Configure Agents.
    2. On the Select an Agent Group dialog, select the agent group that you had configured while installing the connectivity agent.
    3. Click Use.
  6. On the Oracle Apache Kafka Connection window, click Save.
  7. Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again. You get a confirmation message if your test is successful.
  8. Click Back Go back icon to return to the Configuration Editor page.

Configure the Oracle ATP Connection

  1. On the Configuration Editor page, select Oracle ATP Connection.
  2. Click Edit Edit icon.
    The Oracle ATP Connection window appears.
  3. Under Connection Properties, in the Service Name field, enter the service name of your Oracle ATP instance.
  4. Under the Security section, enter the following details:
    • In the Security Policy field, select JDBC Over SSL from the drop-down list.
    • In the Wallet field, click Upload to upload the credential wallet file that you obtained earlier.
    • Enter the password for your credential wallet file in the Wallet Password field.
    • Enter your Oracle ATP account username in the Database Service Username field.
    • Enter your Oracle ATP account password in the Database Service Password field.

    See Configure Oracle Autonomous Transaction Processing (ATP).

  5. Click Save on the connection window.
  6. Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again. You get a confirmation message if your test is successful.
  7. Click Back Go back icon to return to the Configuration Editor page.

Configure the Lookup Table

Edit the lookup table to enter the necessary details.

  1. On the Configuration Editor page, select the lookup table and click Edit Edit icon.
  2. Edit a lookup. For example, against the toEmail field, enter the email address to which run time exception emails are to be sent.
    You can update and modify the lookups as per your requirement.
  3. Click Save. If prompted, click Save for a second time.
  4. Click Back Back icon to return to the Configuration Editor page.