oracle fusion

Oracle Fusion FBDI File Based Data Import with example

Oracle Fusion FBDI File Based Data Import with example

In Oracle Fusion many technologies has been changed. New technologies like BIP Reports, BPEL, SOA, FBDI etc. has replaced technologies like RDF Reports, Workflows, and Oracle Interface etc.

In this post we will be talking about Oracle Fusion FBDI: File Based Data Import.

In Oracle EBS, We are using Oracle Interface Table and APIs to load data in Base Tables, but here in Oracle Fusion FBDI is used to load data.

Benefits of using FBDI:

  • Easily handle huge volumes of Data.
  • Loads data from Flat-file that is placed on FTP Server to interface tables.
  • Enterprise Scheduler Service (ESS) Jobs move data to Fusion Applications base tables
  • Interface tables and the processing job descriptions can be found in Oracle Enterprise Repository (OER)

Steps for File Based Data Import

  1. Go to Oracle Enterprise Repository and select the module and download the template.
  2. Prepare the Data conversion file and generate .csv & .zip files.
  3. Upload .zip files to Oracle cloud.
  4. Login to fusion application and submit the Load Interface file for Import process.
  5. Submit the Product specific Import Job.
  6. Review the Output for any errors.

Step to Upload Suppliers through File Based Data Import.

Step1: Download Template from OER:
  • https://fusionappsoer.oracle.com/oer/index.jsp
  • Login as Guest User(no password required but need MOS account)
  • Type : Select “File Based Data Import”
  • Product Family: “Procurement”
  • Version: Select version(e.g. 11.1.9.0.0)
  • Select Details Tab
  • Select Spreadsheet Template link

Step 2: Prepare Data

Step 3: Generate .csv and Zip File(s).

Interface table names are in bookcase format. For example: POZ_SUPPLIERS_INT will have a .csv (comma separated value) file with name PozSuppliersInt.csv

Step 4: Login to Fusion Applications and navigate to file export and Import.

Step 5: Upload .Zip file to Oracle Cloud.
  • Click on Create Upload
  • Browse local drive to select .zip file created in Step 3 .
  • Select Account – prc/supplier/import
  • Save and Close

Step 6: Submit Load Interface File for Import.

Click Navigator -> Tools -> Scheduled Process

Select ESS Job ‘Load Interface File for Import’

Select the Import Process ‘Import Supplier’ and your zip file uploaded in the previous step Submits 2 Child ESS jobs

•Transfer File

• Load File to Interface

Step 5: Submit Product specific Import Job.

Submit ‘Import Supplier’ ESS Job

Step 6: Submit Load Interface File for Import.

Step 7: Review Load Interface Process to Check Status.

Step 8: Sample Output.
Step 9: Troubleshooting

Review Log and Outputs of ESS Jobs.

Hope you enjoyed reading the article…Cheers!!!

Leave a Reply