Oracle Application's Blog: Part -1 Oracle Fusion : What is FBDI. FBDI process in oracle fusion.Step by Step to Load Suppliers Through FBDI

What is FBDI and FBDI Process in Oracle fusion .Step by Step to Load Suppliers Through FBDI.

Hi Friends, We are going to share about Oracle Fusion FBDI. We will discuss , What is FBDI and details step to load the suppliers through FBDI in Oracle Fusion. FBDI is the data uploading tool in oracle fusion. FBDI helps to upload the data in to the Oracle Fusion. Oracle fusion has provided the hundreds of FBDI data templates as per the requirement which helps to upload the different types of data in Oracle Fusion. In this post , We will discuss in more detail with complete screenshots to upload the suppliers data in Oracle Fusion FBDI.

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 other Application or integrate oracle Application with other external applications. FBDI process in Oracle Fusion is used for Loading mass of Data. Here I will describe what is FBDI and How its work in Oracle Fusion. I will also share Step by Step to Load Suppliers Through FBDI.

Yes , In Fusion our way of working will be change. We will use new tools , new technologies(SOA,ADF,BIP,FBDI,OTBI). We use oracle cloud fbdi templates to load data in Cloud. We put data in these FBDI Templates and then upload these templates in Oracle Fusion.

Free Oracle Fusion Certifications Dump's (Click to Download)

Complete Tax Setups in Oracle Fusion

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.

Oracle FBDI Templates. Oracle cloud erp FBDI process detail description in the Second Part of this Post.

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.

FBDI:-

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.

Step by Step to Load Suppliers Through FBDI

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

FBDI Template oracle

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.