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 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 Enter 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 Public Key Authentication..
    User Name Enter the user name to connect to your sFTP server.
    Private Key File Upload the private key file for your sFTP 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 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 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 Lookup Table

Edit the lookup table to specify the FTP server directory from which the file must be read, the name of the file to be read, and an email ID to receive error messages.

  1. In the Lookups section, click the lookup name.
  2. In the lookup table, enter the following information.
    Property Name Information to Enter
    FTPImportFileName Specify the name of the file to be read from the FTP server. For example, apPaymentRequest. See Access Your FTP Server and Upload the Files.
    emailErrorNotificationTo Enter an email ID of your choice.
    FTPImportDirectory Specify the path of the directory on your FTP server from where the file must be read. For example: /home/user2/FTP.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.