How to Use the Oracle FND_LOAD tool to synchronize data between different instances (Example)

FNDLOAD is a Data Synchronization tool officially provided by Oracle. Generally, we use the FNDLOAD tool to download the custom AOL Data of DEV Instance to a text file, then, use FNDLOAD to upload data to the PROD Instance.

Under what circumstances should FNDLOAD be used for synchronization?

In the test environment, we developed some custom programs (Personalization), Concurrent Program, Message... to synchronize to the formal environment, then we can use the FNDLOAD synchronization tool.

Which data can be synchronized using FNDLOAD?

* Concurrent Programs, Executables
* Request Groups, Request Sets
* Profile Options
* Key and Descriptive Flexfields
* Menus and Responsibilities
* Forms and Form Functions
* Attachments
* Messages
* Value Sets and Values
* Lookup Types
* User Responsibilities
* Printer Definitions
* FND Dictionary
* Help Configuration
* Document Sequences
* Concurrent Manager Schedules

FNDLOAD usage syntax

FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1 | ..]
The mode is either DOWNLOAD or UPLOAD.
The configfile is the file that Fndload needs to download on upload data.
The data file is the output file, in which the downloaded data is written
The entity is the entity you want to download,
Parameters van is passed to download a certain Alert

A Example How to download Personalization Code

I wrote a simple Personalization code to Move Order form in the test environment. The Function Name is INV_INVTOMAI.

1 2 3 Next Page