File Based data import for oracle procurement cloud r12

File Based data import for oracle procurement cloud r12

In this post , We will discuss about File Based data import for oracle procurement cloud r12. Oracle fusion has given the File Based data import (FBDI) tool to import the data from external application or from external source to the oracle Fusion application. File Based data import is the complete process , which involves multiple steps to import the date in the oracle fusion application. Here below I will share the complete steps for File Based data import for oracle procurement cloud r12 which you can refer as an example to import data.

 

 

6 Important Steps of File Based data import for oracle procurement cloud r12

 

 

Step-1:- Download template from Oracle Enterprise Repository (OER) 

 

Step-2:-Prepare Data conversion file & generate .csv & .zip files 

Step-3:-Upload the zip file to Oracle Cloud 

Step-4:-Login to Fusion Applications 

Step-5:-Submit the Load Interface File for Import process 

Step-6:-Submit the product specific import job 

Step-6:-Review output file for any errors.

 

Step1- First we need to download Supplier Data Template from Oracle Repository.

Go to this path for Oracle Repository.

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

 

FBDI Template oracle

 

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

 

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.

Oracle FBDI r13

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.

Step-9:- Login to Oracle Fusion and go to 'File Import and Export ' option as below.

 

Step-10:- Click on Create Upload

 

 Browse local drive to select PozSuppliersInt.zip  file

 Select Account – prc/supplier/import.

Click Save and Continue.

Step-11 :- Once the File will be Imported.

Click Navigator -> Tools -> Scheduled Process

Step-12:- Select ESS Job ‘Load Interface File for Import’

 

Step13:- Go to the Procurement Module in Fusion and Select supplier.

Step:-14 : Under Supplier ==> click on Import Supplier

Step 16:-Select the Import Process ‘Import Supplier’ and your zip file uploaded in the previous step.

Step17:- Import Suppliers Parameters

Step18:- 

Supplier Has been created as Below

 

Please share your comments and feedback about this Post.



If you want to see Other OAF Related Posts , Please visit Below URL.
https://rpforacle.blogspot.in/2013/03/oaf_10.html

If you want to see  Oracle Fusion Related Posts , Please visit Below URL.
https://rpforacle.blogspot.in/2018/01/oracle-fusion-learning-tutorial.html
If you want to Learn Oracle Workflow Builder, Please visit Below URL.
https://rpforacle.blogspot.in/2018/01/oracle-workflow-learning-tutorial-1.html