Friday, 29 December 2017

Part -1 Oracle Fusion : What is FBDI and How its work in Oracle Fusion. Step by Step to Load Suppliers Through FBDI.

                                                       FBDI PART-1

Hi Friends, In coming post I am going to share you all about Oracle Fusion or Oracle Cloud. In oracle fusion , oracle has given FBDI to import data from outer Application or integrate oracle Application with other external applications.FBDI is a very useful toll in FBDI for Loading mass of Data. Here I will show you how we can import suppliers through FBDI in Fusion.

Yes , In Fusion our way of working will be change. We will use new tools , new technologies(SOA,ADF,BIP,FBDI,OTBI) and new methodologies but still workforce will always be there to support and to work on these technologies. These fusion technologies are very easy to use and learnt.

FBDI means File Based Data Import

In this post I am going to Discuss about FBDI. FBDI means File Based Data Import.

In Oracle Apps we uses Interface tables and Oracle API to insert data in Oracle Base Tables or To make integration of Oracle EBS with other software we took help from Interfaces and API.

Really in Oracle apps , Data Loading was a complex job.

Oracle Apps Data Loading Steps.

1.Prepare data Templates and get data in these templates from business for Suppliers , customer and Items.
2. Then create SQL loader programs to Load data from These Data Templates.
3.Run Custom Import programs to insert data from staging table to Interface tables.
4.Finally run import program to load data in Oracle Base tables.

But my friends in Fusion this thing will gone be easy we don't need to take lot of pain during data load. Oracle has already provided standard data templates for each module and each interface.we just need to download these data templates and put data in these data templates and upload this file to cloud and run scheduled processes to move the data in interface tables.

  • Recommended for high volume data import
  • Loads data from flat files that are placed on a secure FTP server into 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)

FBDI Data Import Steps.

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.

In my Next post FBDI Part-2 we will try to upload suppliers through FBDI in Oracle Cloud.


Post a Comment