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

How to do Integration with Oracle Fusion cloud

How to do Integration with Oracle Fusion cloud

 

In this post , We are going to Discuss how we can do Integration with Oracle Fusion cloud. Oracle has provided many tools in fusion , through which we can integrate with it. I am going to discuss integration tools in details.

 

 

1. ADFDI :- Oracle fusion has developed with Application Development Framework(ADF) and it has provided ADFDI tool means ADF Desktop Integration tool to do integration with fusion.

 

ADFDI is similar like WEBADI in Oracle Apps r12. It integrates with Oracle Fusion same like WEBADI in R12.

The integration provided with ADFDI includes interactivity that enables web picker to search for valid values, perform validation during data entry, display error messages, and immediately submit transactions directly from MS Excel.

 

This tool is very useful for Small value of Data uploading in Oracle Fusion. I will create post related to this topic in future.

 

2.FBDI :-

 FBDI Stands for File Based Data Import. This is a very good tool to do integration with Oracle fusion when you are dealing with High volume of Data. This FBDI is same as Data Import in Oracle Apps r12 through Interfaces. In FBDI , we download standard Oracle data Templates from Oracle Repository specific to the process like customer, supplier,item,ar invoice and then we put data in these templates and upload these data files in fusion and then run the standard import processes to move data in Fusion Standard interface Tables.

This process is very fast as compared to ADFDI and uses for implementations and to handle high volume of Data.

 

3.ADF Services :-

 A web service provides a standard way to integrate two web-based applications. A web service is a program that can be accessed remotely using different XML-based languages. These ADF services calls from Fusion middleware(SOA) to automate processes in Oracle fusion. Fusion has given many standard web-services to do automation in the integration process.

 How to do Integration with Oracle Fusion cloud