Install and Configure the Recipe

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

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Process Automation Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection type Select REST API Base URL.
    Connection URL Enter your Process Automation instance URL.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select OAuth Resource Owner Password Credentials.
    Access Token URI Enter the access token URI.
    Client Id Enter the client Id that you obtained. See Configure Process Automation.
    Client secret Enter the client secret that you obtained.
    Username Enter the usename of the account created for Oracle Integration on the Process Automation instance,
    Password Enter the password of the account created for Oracle Integration on the Process Automation instance,
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the ATP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, specify the database service name in the Service Name field. See Configure Oracle Autonomous Transaction Processing.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select JDBC Over SSL.
    Wallet Select the check box, then click Upload to upload the wallet file. See Configure Oracle Autonomous Transaction Processing.
    Wallet Password Enter the wallet password.
    Database Service Username

    Enter the database service username to connect to the ATP database.

    The database service username is the schema username for the user to log in to the database. The database service username is not the same as the database service name that you specify in the connection Properties section.
    Database Service Password Enter the database service password to connect to the ATP database.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the REST Trigger Connection

  1. In the Connections section, click the connection name.
  2. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the OPA_Audit_Sync_LKP lookup table and enter appropriate values for the lookup keys.

  1. In the Lookups section, click the lookup name.
  2. Edit the lookup keys as per your requirements.
    Key Description
    Email_Notification_To Enter the email address of the recipient to whom error notifications have to be sent.
    Email_Notification_From Enter the email address of the sender who sends error notifications.
    InterfaceName Specify the name of the interface. For example: OPA_Audit_Sync.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.