How to Upload Data Through ADFDI in Oracle Fusion

How to Upload Data Through ADFDI in Oracle Fusion

 

Hi Friends, In this post we will discuss , how to Upload Data Through ADFDI in Oracle Fusion. Fusion has given FBDI and ADFDI tools to upload data in Oracle Fusion. FBDI mostly uses when we have large volume of data and to do automate Integration processes in Oracle fusion. On the other side, ADFI fits better , to those cases when you want to upload data from Excel sheets same like WEBDI in Oracle Apps r12. When you have small volume of Data then ADFDI is really a great option.

 

Second good thing in ADFDI is that , it provided real time interaction with Fusion Application. It means you select values from List of Values from the ADFDI Excel sheets. Like BU ,Supplier, Its Sites. So if you are entering any wrong information in ADFDI template which does not exists in Fusion Application , it will give error on the same time when you are entering this values in the ADFI template but this is not possible in FBDI. FBDI does not provide your selection and list validation from the Application. in FBDI you will get errors when you will trying to import data in fusion Base Tables.

 

Fusion has given you ADFDI for each important function of the Business like (Supplier, customer, AP Invoice ,AR Invoice, GL Journals, Fixed Assets, Purchase Orders and many more).

 

In this Example I will share you the Example of AP invoice through ADFDI.

 

Before using ADFDI, you have to do some settings in your system which you can find in my previous post.

 

Step1:- Go to Payables Roles in fusion.

 

 

Step2:- Go to the right side of the Task list and Select Create Invoice in Spreadsheet option and Save the Excel Worksheet in your Desktop.

 

 

 

Step3:- Open the Saved Excel Workbook and enter the Invoice Details as below.

 

 

 

 

Ste4:-  After Inserting Data in Excel Workbook click on create Invoices Tab as below and Submit the Invoice Import , your data will be start uploading in fusion application after that.

How to Upload Data Through ADFDI in Oracle Fusion