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 URL to access your Oracle ERP Cloud instance in the ERP Cloud Host field.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    Username 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.
  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 FTP Connection

  1. If you are using an external FTP, find out the IP and port where the FTP server runs.
    If you are using File Server, find its IP and port:
    1. In the navigation pane, click Settings, then File Server, then Settings.
    2. From the General section, copy the IP and port.
  2. In the Connections section, click the connection name.
  3. In the Properties section, enter the following details:
    1. FTP Server Host Address: the IP for your external FTP file server or the IP you copied from the File Server settings. For instance, server123.company_name.com.
    2. FTP Server Port: the port for your external FTP file server or the port you copied from the File Server settings. For instance, 21.
    3. SFTP Connection: specify the value as No.
  4. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    User Name Enter the user name to connect to your FTP server.
    Password Enter the password to connect to your FTP server.
  5. Click Save. If prompted, click Save again.
  6. 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.
  7. To return to the project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the values of the lookup keys in the ORCL-BRT-FTP_FOLDER lookup table.

  1. In the Lookups section, click the lookup name.
  2. In the Property_Value column for directory, replace /InputDirectory with the path to the directory where you want to store the CSV file. See Access Your FTP Server.
    If you are using File Server, enter the path that you wrote down when you enabled File Server for your user.
  3. In the Property_Value for filename replace the default value CVS with the name you want to use for the file that stores the purchase order data. For example: PurchaseOrders.csv
  4. Click Save. If prompted, click Save again.
  5. To return to the project workspace, click Go back Back icon.