Before You Install the Recipe

You must perform the following configuration tasks on your Process Automation andOracle Autonomous Transaction Processing instances in order to successfully connect to these external systems using Oracle Integration and synchronize audit, history and comments data.

Configure Process Automation

To successfully connect to Process Automation using Oracle Integration and synchronize audit, history, and comment records, you must perform certain configuration tasks on the your Process Automation instance.

  1. Configure an OAuth application for Process Automation.

    Developer APIs for Process Automation and Process Automation REST endpoints are protected using OAuth token-based authentication.

    1. Sign in to the Oracle Identity Cloud Service administrator console.
    2. Click Applications and then Add.
    3. Select Confidential Application as the application type, enter the application name, and then click Next.
    4. Select Configure this application as a client now.
    5. Under Allowed grant types, select Resource owner.
    6. In Client type, select Confidential.
    7. In Allowed scopes, click Add and select your Process Automation instance from the list. Your instance name will be the instance ID. After the instance is selected, the application shows the configured scopes for the instance. You can select the required scopes (for example, /process).
    8. Click Next and skip the rest of the sections, and then click Finish.
      A confidential OAuth application is created.
    9. Copy and save the Client ID and Client Secret for the application that is displayed and click Close.
    10. Click Activate, then click OK to confirm that you want to activate the application.
    11. Assign the ServiceDeveloper or the ServiceAdministrator role. For more information, see Assign the application to the ServiceDeveloper role in Using Oracle Cloud Infrastructure Process Automation.
  2. Assign the Process Application Administrator global role to the application you configured in the previous step.
    1. Sign in to your Process Automation instance as an administrator.
    2. From the Process Automation Workspace navigation pane, click Administration, and then click Roles.
    3. Under the Global tab, select Process Application Administrator.
    4. In the Search by field, select External applications and then search and select the OAuth application that you configured.
    5. Click Save.

Configure Oracle Autonomous Transaction Processing

Sign in to your Oracle Autonomous Transaction Processing instance as an Administrator and perform the following tasks.

  1. Perform general configuration tasks. See Prerequisites for Creating a Connection in Using the Oracle Autonomous Transaction Processing Adapter with Oracle Integration 3.
  2. In SQL developer, run the script to create schema.
    The following script creates a schema in ATP database: 01_Create OPA Schema.sql
  3. In SQL developer, run the script to create database tables and necessary indexes.

    The following script creates the database tables listed below: 02_OPA_AuditSync_DBObjects.sql

    • XX_OPA_PROCESS_INSTANCE: Stores high-level process instance information.
    • XX_OPA_PROCESS_ACTIVITY_INSTANCE: Stores process instance activity details.
    • XX_OPA_PROCESS_TASK_HISTORY: Stores process task history details.
    • XX_OPA_PROCESS_COMMENTS: Stores process comments details.
    • XX_INTERFACE_LASTRUNTIME: Stores details about the last runtime when the data synchronization was performed.
  4. In SQL developer, run scripts to create database package.
    On running the scripts, the database package XX_OPA_AUDIT_SYNC_PKG with four procedures is created.
    1. MERGE_OPA_PROCESS_INSTANCES
    2. MERGE_OPA_ACTIVITY_INSTANCE
    3. MERGE_OPA_TASK_HISTORY
    4. MERGE_OPA_PROCESS_COMMENTS