FNDLOAD

FNDLOAD is an Oracle utility for the transfer of a wide range of Oracle Foundation (FND) data from one instance to another instance. It can be defined as a concurrent program that can move Oracle Applications data between database and text file or this can be defined as FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database. 

* For Downloading a Concurrent Program

FNDLOAD apps/uatapps@uat 0 Y DOWNLOAD /u01/UAT/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afcpreqg.lct XX_MY_REQUEST_GROUP_NAME1.ldt REQUEST_GROUP "All Reports" APPLICATION_SHORT_NAME="XXAJ_SSR"

Note: XX_MY_REQUEST_GROUP_NAME1.ldt is the name of outputfile

* For Upload a Concurrent Program

FNDLOAD apps/$CLIENT_APPS_PWD O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct

These are the list, of configuration file and it’s Purpose 

afattach.lct : Load attachments setup data 

afcpprog.lct : Concurrent Program Definitions 

afcppstl.lct: : Concurrent Program Printer Styles 

afcpreqg.lct : Concurrent Request Groups 

afcprset.lct : Concurrent Request Sets 

afffload.lct : Flexfields (KFF, DFF, value sets, value sets data) 

aflvmlu.lct : Lookup types and codes 

afscprof.lct : Profiles and Profile Values 

afscursp.lct : Security data (users, responsibilities, etc) 

afsload.lct : Menu / Function Security Data•Lookup Types