Oracle Fusion or Oracle Cloud
In oracle fusion, Oracle FBDI to import data from outer Application or integrate Oracle Application with other external applications.
FBDI for Loading mass of Data
File-Based Data Import
Oracle Apps knowledge Loading Steps.
1. Prepare data Templates and acquire data in these templates from business for Suppliers, customer, and items.
2. Then produce 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.
Oracle has already provided standard data templates for every module and every interface. we simply need to download these data templates and place 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 the Import process
Step-6:-Submit the product-specific import job
Step-6:-Review output file for any errors.
1 comments
Nice post, very interesting to read and understand, hope post more blogs with more information Thank you Please contact us for Oracle R12 Financials Training in Ameerpet details in our Erptree Training Institute
ReplyDelete