Know about FND LOADER:

      In an oracle implementation, usually setups are done in a development instance which need to be migrated to test and production instance. FNDLOAD can be used to create data files from the source instance and then this data file uploaded to target instance. The data file thus downloaded can be moved from one instance to another instance as a source controlled file.

Oracle provides a utility to download and upload the metadata files from one instance to the other. This utility will save lots of time in configuring an instance.

The FNDLOAD program can migrate entities like Attachment Definition, Concurrent Programs, Printers and Printer Styles, Value-Sets, Request Groups, Request Sets, Form Personalization, Lookups, Responsibilities, Applications, Profile Options, Users, Form, Functions and Menus, Document Sequences, Descriptive and Key Flex Fields.
BI publisher files and metadata also can be migrated from one instance to the other. I will discuss that in my next post.
To download data for a particular entity, it makes use of a definition file (called .lct file). These definition files are standard files (for each standard entity) and are available in the directory, $FND_TOP/patch/115/import/. For example, to download a concurrent program, a definition file afcpprog.lct is used.
Output data file is created with an extension .ldt. This data file can then subsequently be uploaded into other environment using FNDLOAD command with upload parameter.

For example, suppose there is a concurrent program defined in development instance. We want to migrate this concurrent program from development to Test instance. The can be achieved using the following two steps:

a. Run the FNDLOAD command (in Development instance) in DOWNLOAD mode, using definition file afcpprog.lct to create a .ldt file.

b. Run the FNDLOAD command (in Test instance) in UPLOAD mode, using the data file created in step (a) above.

This FNDLOAD program runs in UNIX environment. The mode can be Download or Upload. The configuration file .lct file will be present in $FND_TOP/patch/115/import directory. The output will be stored in the .ldt file.
There are some standard configuration files available. They are given in this link.
http://oracleapps4u.blogspot.in/2011/08/working-with-fndload-in-oracle-apps.html

Examples on Upload Download of Commonly used Entities
Concurrent Program

Download

FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="<Short Application Name>" CONCURRENT_PROGRAM_NAME="<concurrent program short name>"

Upload

FNDLOAD apps/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt