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 Oracle ATP ImportAccountTransaction 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 ATP.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select JDBC With OCI Signature.
    Wallet Select the check box, then click Upload to upload the wallet file. See Configure Oracle ATP.
    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.
    Object Storage Region Specify the region in which your object storage is located. For example, us-ashburn-1.
    Object Storage Tenancy OCID Specify the value you copied from the Oracle Cloud Infrastructure Console. For example, ocid1.tenancy.oc1.alphanumeric.value
    Object Storage Compartment OCID Specify the value you copied from the Oracle Cloud Infrastructure Console. For example, ocid1.compartment.oc1.alphanumeric.value
    Object Storage User OCID Specify the value you copied from the Oracle Cloud Infrastructure Console. For example, ocid1.user.oc1.alphanumeric.value
    Private Key Click Upload to select the key you created. Ensure that the key is in RSA (PKCS1) format.

    Note:

    Only a private key without a pass phrase/password is supported.
    Finger Print Enter the finger print that was generated when you created the key in the Oracle Cloud Infrastructure Console.
  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 Oracle ERP SOAP ESS ImportAccountTrans Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, specify the WSDL URL. For example: https://<ERP Hostname>/publicFinancialCommonErpIntegration/ErpIntegrationService?wsdl.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username Enter the user name.
    Password Enter the password.
  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 Oracle FTP ImportAccountTransactions Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Address Enter the host address of your sFTP server.
    FTP Server Port Enter the port of your sFTP server.
    SFTP Connection Select Yes from the list.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    Username Enter the username to connect to your FTP server.
    Password Enter the password to connect to your FTP server.
  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 Oracle ERP ImportAccountTransactions Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username Enter the username 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.
  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.