Overview:

In this blog, we will walk through the process of configuring the Oracle ERP Cloud Adapter within Oracle Integration Cloud (OIC) for importing bulk data using File Based Data Import (FBDI) into ERP. This blog will utilize the use case of importing Accounts Receivable (AR) Invoices by configuring Oracle ERP Cloud Adapter for importing bulk data using File Based Data Import (FBDI).

Steps to Build Integration:

  1. Get the required fields from the flat file by configuring its respective adapter.
  2. The records are looped and CSV files for the FBDI are created in the OIC stage and its values are mapped from the looped records to create the CSV template.
  3. A properties file with a .csv extension has to be written for the AR (Auto Invoice) program to run the FBDI.
  4. All the CSV files are zipped and passed to Oracle ERP Cloud adapter to run the program.
  5. A call back integration is created with app-driven orchestration to run immediately after the program running is completed to check the status of the load.

Below are detailed steps to achieve this integration

  1. Connections are in the left pane of OIC, the connections are created. Connections are configured by selecting the required adapters and providing the credentials. Steps to achieve | Oracle Integration Cloud
  2. In the Integrations pane, Schedule Orchestration is selected in Create for building new integration.Integrations pane | Oracle ERP Cloud
  1. The Source system connection is configured and is used as invoke to get the required fields from the source to be used in the FBDI mapping.
  2. The FBDI file is built in the OIC stage and the values are mapped from source to FBDI template fields:FBDI mapping | Tangenz Corporation

FBDI mapping | Tangenz Corporation

  1. Properties file which includes the job definition and package names as well as the job parameters of the object being imported are written in the OIC stage along with the FBDI template for calling the program. The job property file is in CSV format as follows:
    <job package name>,<job definition name>, <ZIP file prefix>,<Param1>,….<ParamN>
    All the files are zipped and passed to Oracle ERP Adapter.
    Oracle ERP Adapter | Tangenz CorporationOracle ERP Adapter | Tangenz CorporationOracle ERP Adapter | Tangenz Corporation
  2. Another Integration with App Driven Orchestration (Step 2) is created for the call back of the FBDI Process to check if the FBDI Data import is succeeded or failed. The ERP Adapter is used as a trigger in this integration to trigger when the FBDI import process is complete.
    App Driven Orchestration | Tangenz Corporation
    App Driven Orchestration | Tangenz Corporation
  3. The zipped file from the call back is unzipped and read to check for errors.

zipped file | Tangenz Corporation

Considerations:

Job Properties File:

The FBDI bulk data import operation requires a job property file that provides ERP with details of data to load. The properties file includes the job definition and package name as well as the job parameters of the object being imported. The name of the properties file could be anything but the extension must be the .properties file.

How to get Job Package Name and Name:

From Fusion Apps main page,

  1. Click the Navigator, and then click Setup and Maintenance.
  2. On the Setup page, select your setup offering such as FinancialsImporting Bulk Data into Oracle ERP Cloud using FBDI through OIC | Tangenz Corporation

Click on the right icon as shown above to search for “Manage Enterprise Scheduler Job Definition and Job Sets for Financial, Supply Chain Management and Related Applications”:

Select and Click “Manage Enterprise Scheduler Job Definition and Job Sets for Financial, Supply Chain Management and Related Applications” and search for “%Import AutoInvoice%” as shown below:

Importing Bulk Data into Oracle ERP Cloud using FBDI through OIC | Tangenz Corporation

Select the “Import AutoInvoice” row and click edit

Importing Bulk Data into Oracle ERP Cloud using FBDI through OIC | Tangenz Corporation

From the above image, the job package is the PATH, and the job name is the NAME. These will be the first two columns in your property file for “Import AutoInvoice” with the third column the sample prefix name of the zip file.

How to get a list of parameters

Once we have the job package and name, the next step is to determine the list of parameters for the “Import AutoInvoice” job. Please follow these instructions:

From Fusion Apps main page,

  1. Click the Navigator, and then click Scheduled Processes in Tools.
  2. Click on the “Schedule New Process” button and search (and select) for “Import AutoInvoice”. It will display the list of parameters.

Callback

Bulk import in Oracle ERP Cloud integration service is a long-running process that requires an asynchronous callback pattern to notify the user upon job completion. The ERP callback returns the status of the bulk process including all the sub-processes executed implicitly. It includes the log and error files (compressed in a ZIP format) of each sub-processes and the original data file. These details highlight any issues that the import job had importing the data. This enables the automated handling of success and failure within an OIC integration and may be used to trigger further business processing of the result.

Connections Required:

  1. Third-Party Source System Adapter
  2. Oracle ERP Adapter
    Url: https://<<erp hostname>>/

UserName:

Password:

Oracle ERP Adapter

If you need any help with your Oracle ERP Cloud implementations, Please drop a line here. Our Oracle ERP experts will contact you promptly.