Introduction
In this article, I will explain how to build an integration
in Oracle Integration Cloud (OIC) Generation 3 to import
supplier data into Oracle ERP Cloud using the File Based Data Import
(FBDI) process.
Oracle Integration Cloud provides multiple adapters to
communicate with external systems such as:
- Oracle
ERP Cloud
- Oracle
ATP (Autonomous Transaction Processing)
- Amazon
Web Services (AWS)
- SAP
- And
many more
For a complete list of available adapters, refer to the
official Oracle documentation:
https://docs.oracle.com/en/cloud/paas/application-integration/find-adapters.html
Why Use FBDI?
The Oracle ERP Adapter allows you to import
bulk data using File Based Data Import (FBDI). FBDI is the most
efficient method for mass data conversions, enabling large volumes of data to
be imported in the shortest possible time.
Oracle provides FBDI templates to import bulk data from
external sources into Oracle Fusion. Before uploading, you must:
- Download
the appropriate FBDI template for your entity
- Prepare
a structured FBDI file based on the template
Each job (Supplier, AR, AP, etc.) has its own dedicated FBDI
template.
📥 Example –
Download Supplier FBDI Template: https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/26b/oefsc/index.html
Problem Description
Client Requirement:
The client provides multiple supplier records in a CSV file placed
on an SFTP location. These suppliers must be imported regularly
into Oracle Fusion Applications.
Sample CSV File:
Solution:
Automate this process by building an integration in Oracle Integration
Cloud (OIC) Generation 3.
End-to-End Process Flow
The diagram below illustrates the complete integration
process to import suppliers into Oracle ERP via OIC:
Step by Step process
Step-by-Step Integration Process
Step 1: Configure Variables (Assign Step)
In this step, we assign the necessary variables that will be
used throughout the integration.
Step 2: Download File from SFTP (Stage File Call)
Invoke the Stage File action to download
the CSV file from the SFTP location.
Key variables to configure:
Step 3: Prepare the CSV File
Create or transform the CSV file that will later be zipped
and uploaded via the Oracle ERP Adapter.
Step 4: Create the Property File (Critical Step)
This is a very important part of the
process. The property file contains the ESS job parameters required by the
Oracle ERP Adapter.
For file column names, refer fist assignment screenshot above,
from 2nd to 6.
Property file mapping
Step 5: Create ZIP File
Create a ZIP file containing the prepared CSV and property
file.
Inputs required:
- Source
file name (from variable defined in Step 1)
- Directory
to zip
- Output
ZIP file name (from variable)
This Stage file required a file name which we have already defined
in first assignment as variable ans the same we have passed here
And then Directory to Zip and Output
Step 6: Map ZIP File to Oracle ERP Adapter Request
After the ZIP file is created, map the file
reference and file name from the ZIP output to the
Oracle ERP Cloud Adapter request.
Step 7: Configure Oracle ERP Adapter
Adapter Action:
Select "Import Bulk Data into Oracle ERP Cloud"
Then search for Import Suppliers ESS
Testing the Integration
Step 1: Run the Integration
Click Run to execute the integration.
Step 2: Verify Execution Status
The integration executes successfully with no errors
or warnings.
Step 3: Verify in Oracle Fusion Application
Navigate to Oracle Fusion and check
the ESS Jobs history. The Import Suppliers ESS job should show
a successful execution status.
Step 4: Verify Supplier Creation
Confirm that suppliers have been successfully created in
Oracle Fusion.
Conclusion
In this blog post, we successfully demonstrated how to:
✅ Read a supplier CSV file from
an SFTP location using OIC Gen 3
✅
Convert the CSV into a ZIP file compatible
with FBDI
✅
Create a property file containing
ESS job parameters
✅
Invoke the Import Suppliers ESS job via
the Oracle ERP Adapter
✅
Verify successful supplier creation in Oracle
Fusion Applications
This approach can be extended to other FBDI entities such
as:
- Customers
- Items
/ Products
- Invoices
- Purchase
Orders
Additional Resources
For more information, refer to the official Oracle
documentation: https://docs.oracle.com/en/cloud/paas/application-integration/index.html