Integration of Supplier Information from External System or Third Party Tool to Oracle Fusion Automatically

Integration of Supplier Information from External System to Oracle Fusion Automatically

In this post , I will show you the steps how we can do automate integration between external third party software and in Oracle Fusion. We all know that , Oracle Fusion has provided FBDI and ADFDI features to do integration with Oracle Fusion but this process involved manual intervention. We need to prepare FBDI data template or ADFDI templates and then upload in Oracle fusion and if we want to automate integration then we need to get other process that will be automate without doing any manual intervention.

 

Step1:- In this Example we are integrating Supplier Information from External system to Oracle fusion.

 

Step2:- First download the Supplier FBDI Template from Oracle Repository.

 

Go to this path for Oracle Repository.

http://www.oracle.com/webfolder/technetwork/docs/HTML/oer-redirect.html

Step-2:- Go to Procurement Tab as below and Click on Release 11 under File-Based Data Import.

Step-3:- Then this below screen page will open.

Step 4:- Under File-Based Data Imports click on Import Supplier Data Template.

 Step-5:- Click on XLSM template and save the data Template in our Desktop.

Step-6:- This is the Below Data Template for Import Supplier.

First Tab is the Instruction tab and Second Tab is the Data Template in which we will put data for suppliers.

Step-7

I am going to create TEST SUPPLIER through FBDI.

Step-8:- After Putting data in Data Template and then go back to first tab and Click on Generate CSV File button as below.

This will create PozSuppliersInt.zip file in your local system.

Step9:- Now open the PozSuppliersInt.csv file and read the pattern of the csv file like what's the data format of this csv file , how the pattern of the FBDI data template columns. Check is there any other character involved in this csv file except Data Template columns.
The Whole idea is that , we will study the CSV file and try to create that csv file directly from Third Party software without doing using the FBDI data template.

This is the csv file created from the FBDI template and we will get the Supplier Information from Third Party Software in this File Format so by that way there will be no manual involvement in this task.

Step10:- We will put this File directly in the ucm path prc/supplier/import

Step1-:- Then We will schedule the Program in Oracle Fusion 'Load Multiple Interface Files for Import'

Here you can see below , I have selected Import process 'Import Suppliers' and File Prefix 'PozSuppliersInt' then after that click on Advanced button above to schedule this process.

 

Schedule this program as below and now your Data Import process has been automate :)

 

 

 

Integration of Supplier Information from External System to Oracle Fusion Automatically