1. Import Customer Records from an FTP Server to Oracle ERP Cloud
  2. Install and Configure the Recipe

3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Use a recipe/accelerator section, click View all.
  2. Find the recipe you want to install, then click Get.

    A message confirms that the recipe was successfully installed, and the recipe card shows In use.

  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle ERP Connection

Use the following steps to configure the Oracle ERP Connection 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.
    User Name 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 Oracle FTP Connection

Use the following steps to configure the Oracle FTP Connection 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.