1 About This Recipe

Use this recipe to import suppliers from File Server to Oracle ERP Cloud.

Note:

Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe imports an interface file containing supplier information from File Server to Oracle ERP Cloud according to a schedule specified in Oracle Integration.

In this recipe, File Server is used to store the supplier file and a native File Server action is used to list and read the file.

This recipe contains the following integration flows:
  1. Oracle FTP ERP Import Suppliers: This is a schedule-based integration flow that reads the file from File Server, does the conversion as per the suppliers FBDI file and imports it into Oracle ERP Cloud using the Oracle ERP Cloud adapter.
  2. Suppliers Callback: This is an event-based integration flow that will be called once the Import Suppliers job is completed in Oracle ERP Cloud. This flow uploads the log file to File Server.

To use the recipe, you must install the recipe and configure the connection and other resources within the recipe.

To use File Server, which is an embedded sFTP server within Oracle Integration, you must enable it from your Oracle Integration instance. See Enable File Server in Using File Server in Oracle Integration 3.

You can also use an external FTP server instead of File Server but you would need to configure the FTP adapter connection if you are using an external FTP server.

System and Access Requirements

  • Oracle Integration 3

  • Oracle ERP Cloud

  • An account on Oracle ERP Cloud with the Administrator role

  • File Server