FNDLOAD Utility in Oracle Apps

Here in this post we will see how to use the FNDLOAD utility in Oracle e-Business Suite.

Frequently used FNDLOAD commands

1. Concurrent programs with the parameters 
2. Lookup Types and lookup values
3. Profile Options and profile values
4. Flex-fields setup data
5. Request Set
6. Request Groups
7. Alerts 
8. Responsibilities
9. Form Personalisation
10. Form Functions
11. Menus
12. FND Messages
13. Data Definition and Associated Template

Concurrent Program

Download :

FNDLOAD apps/<Pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CUSTOM_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XXCUST" CONCURRENT_PROGRAM_NAME="XX_CONCURRENT_PROGRAM"

Note: The concurrent program, the associated parameters and the value sets of those parameters will be downloaded in a .ldt file.

Upload:

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

To fetch the Application short name

Navigation : System Administrator -> Applications -> Register

To pick the concurrent program name

Navigation : System Administrator -> Concurrent -> Program -> Define

Lookup Types and lookup values

Download :

FNDLOAD apps/<Pwd>O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XXCUST" LOOKUP_TYPE="XX_LOOKUP_TYPE"

Upload:

FNDLOAD apps/<Pwd>O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_CUSTOM_LKP.ldt  

To pick the Lookup type name

Navigation : Application Developer ->Application -> Lookup-> Application Object Library

Profile options and values

Download :

FNDLOAD apps/<Pwd>O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt PROFILE PROFILE_NAME="XX_PROFILE_NAME" APPLICATION_SHORT_NAME="XXCUST"

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XX_CUSTOM_PRF.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

To pick the Profile name

Navigation : Application Developer ->Application -> Profile

Flexfields setup data and values

Value sets

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt VALUE_SET FLEX_VALUE_SET_NAME="XX Value Set Name"

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_CUSTOM_VS.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

To pick the value set name

Navigation : Application Developer ->Application -> Validation->Sets

Descriptive Flexfields

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct  filename.ldt 

DESC_FLEX APPLICATION_SHORT_NAME='short name' DESCRIPTIVE_FLEXFIELD_NAME='flexfield name'

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct filename.ldt

To pick the descriptive flexfield name

Navigation : Application Developer ->Application -> Flexfield->Descriptive -> Register

Key Flexfields

Download 

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct  filename.ldt 

KEY_FLEX APPLICATION_SHORT_NAME='short name' DESCRIPTIVE_FLEXFIELD_NAME='flexfield name'

Upload

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct filename.ldt

To pick the Key flexfield name

Navigation : Application Developer ->Application -> Flexfield -> Key -> Register

Request Set

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME'

To download the Link Stages for Request Set

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct <LDT_FILE_NAME>.ldt REQ_SET_LINKS REQUEST_SET_NAME="<REQUEST_SET_SHORT_NAME>"

Upload:

FNDLOAD apps/<Pwd> O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_CUSTOM_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

To pick the Request set name

Navigation : System Administrator ->Requests -> Set

Request Group

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <LDT_FILE_NAME>.ldt REQUEST_GROUP REQUEST_GROUP_NAME="<RG name >" APPLICATION_SHORT_NAME="<APP_SHORT_NAME>"

To download a Request Group for a specific Program.

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct <LDT_FILE_NAME>.ldt REQUEST_GROUP REQUEST_GROUP_NAME="<RG name >" APPLICATION_SHORT_NAME="<APP_SHORT_NAME>" UNIT_NAME="<CP_SHORT_NAME>"

Note: In request group name, give the actual name and not the RG code.

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct <LDT_FILE_NAME>.ldt

To pick the Request Group name

Navigation : System Administrator ->User ->Responsibility -> Request 

Alerts

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name"

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE

To get Alert name:

Alert Manger -> Alert -> Define

Responsibility

Download :

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt FND_RESPONSIBILITY RESP_KEY="<RESPONSIBILITY_KEY>"

Upload:

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <LDT_FILE_NAME>.ldt

To Pick Responsibility name

Navigation : System Administrator ->User ->Responsibility -> Define

Form Personalizations

Download :

FNDLOAD apps/<PWD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct <LDT_FILE_NAME>.ldt FND_FORM_CUSTOM_RULES FORM_NAME="<YOUR_FORM_NAME>"

Upload:

FNDLOAD apps/<PWD> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct <LDT_FILE_NAME>.ldt

To get the Form name:

Navigation : Help -> About oracle Applications -> Current Form -> Form name

Form Functions

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt FUNCTION FUNCTION_NAME="<FORM_FUNCTION_NAME>"

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

To get the Form Function name

Navigation : System Administrator ->Application ->Function

Menus

Download :

FNDLOAD apps/<Pwd>  0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME >.ldt MENU MENU_NAME="<Menu_Name>"

To attach a form function with an existing menu

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt MENU PARENT_MENU_NAME="<MENU_NAME>" FUNCTION_NAME="<FORM_FUNCTION_NAME>"

Upload:

FNDLOAD apps/<Pwd>   0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME >.ldt

To get the Menu name

Navigation : System Administrator ->Application ->Menu

FND Messages

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="XXCUST" MESSAGE_NAME="MESSAGE_NAME%"

Upload:

FNDLOAD apps/<Pwd> O Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct XX_CUSTOM_MESG.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

To get the Message name

Navigation : Application Developer  ->Application ->Messages

Data Definitions and Associated Template

Download :

FNDLOAD apps/<Pwd>  O Y DOWNLOAD  $XDO_TOP/patch/115/import/xdotmpl.lct <LDT_FILE_NAME>.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="<APP_SHORT_NAME>" DATA_SOURCE_CODE="<DATA_DEFINITION_CODE>" TMPL_APP_SHORT_NAME="<TEMP_APPLICATION_SHORT_NAME>" TEMPLATE_CODE="<TEMPLATE_CODE>"

Upload:

FNDLOAD apps/<Pwd> 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct <LDT_FILE_NAME>.ldt

Note: The RTF Template file has to be uploaded manually by going to ‘XML Publisher Responsibility’.

To get the Data Definition name

Navigation : XML Publisher Administrator -> Data definitions

To get the Tempalte name

Navigation : XML Publisher Administrator -> Template

For any suggestion or issues with the above code, please leave your comments. I will try to reply back as soon as possible