FNDLOAD
The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file. The loader reads a configuration file to determine which entity to access. In simple words FNDLOAD is used to transfer entity data from one instance/database to other. for example if you want to move a concurrent program/menu/valuesets developed in DEVELOPMENT instance to PRODUCTION instance you can direct use this command. Steps to Move a Concurrent program from one instance(Database) to other Define your concurrent program and save it in first instance(for how to register a concurrent program click here) Connect to your UNIX box on first instance and run the following command to download the .ldt file
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt PROGRAM APPLICATION_SHORT_NAME="Concurrent program application short name" CONCURRENT_PROGRAM_NAME="concurrent program short name"
Find the file_name.ldt file in Instace/product directory.
Move the downloaded .ldf file to new instance(Use FTP) Connect to your UNIX box on second instance and run the following command to upload the .ldt file
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt Note: Make sure you are giving proper .lct file in the commands and dont confuse with .lct and .ldt files These following are the other entity data types that we can move with FNDLOAD 1 - Printer Styles FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name" 2 - Lookups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND" LOOKUP_TYPE="lookup name" 3 - Descriptive Flexfield with all of specific Contexts FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt DESC_FLEX P_LEVEL=COL_ALL:REF_ALL:CTX_ONE:SEG_ALL APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"
4 - Key Flexfield Structures FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt KEY_FLEX P_LEVEL=COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name" 5 - Concurrent Programs FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent program short name" 6 - Value Sets FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name" 7 - Value Sets with values FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name" 8 - Profile Options FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND" 8 - Request Groups FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt REQUEST_GROUP APPLICATION_SHORT_NAME="FND" REQUEST_GROUP_NAME="request group" 10 - Request Sets FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt REQ_SET APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set" 11 - Responsibilities FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility" 12 - Menus FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/[Link] file_name.ldt MENU MENU_NAME="menu_name"
13 - Forms Personalization FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/[Link]
file_name.ldt FND_FORM_CUSTOM_RULES function_name=FUNCTION_NAME
Note: UPLOAD command is same for all except replacing the .lct and passing any extra parameters if you want to pass
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/[Link] upload_file.ldt