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 ERP Cloud 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 the Oracle ERP Cloud instance. See Configure the Oracle ERP Cloud Connection.
    Password Enter the password of the account created for Oracle Integration on the Oracle ERP Cloud 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 Oracle SOAP ERP Integration Service Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the WSDL URL. For example: https://your_domain_name.fa.DC.oraclecloud.com/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 username of the account created for Oracle Integration on the Oracle ERP Cloud instance. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on the Oracle ERP Cloud 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 Oracle FTP 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 22
    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 Lookup Table

Edit the ORCL-BRT-ERP_FTP_EXTRACT_SETTINGS lookup table with appropriate values.

  1. In the Lookups section, click the lookup name.
  2. In the Property_Value column for OutputDirectoryOnFTP, enter the FTP directory path where the BI publisher report has to be uploaded. See Access Your FTP Server.
  3. In the Property_Value column for EmailToInCaseOfFault enter the email where notification emails need to be sent in case of an error.
  4. Click Save. If prompted, click Save again.
  5. To return to the project workspace, click Go back Back icon.