Fndload to Upload Concurrent Job With Request Group

Here in this mail service we will run into how to use the FNDLOAD utility in Oracle e-Business organisation Suite.

Oftentimes 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. Asking Set
6. Request Groups
7. Alerts
8. Responsibilities
9. Grade Personalisation
10. Course Functions
11. Menus
12. FND Messages
13. Data Definition and Associated Template

Concurrent Programme

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 programme, 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 brusque proper noun

Navigation : System Ambassador -> Applications -> Register

To pick the concurrent program name

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

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 blazon 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 Contour 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=Yeah UPLOAD_MODE=Supplant CUSTOM_MODE=Strength

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 Proper name"

Upload:

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

To pick the value ready 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 : Awarding Developer ->Application -> Flexfield->Descriptive -> Annals

                                    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 Primal 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 up

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=Supervene upon CUSTOM_MODE=FORCE

To choice the Request gear up name

Navigation : System Administrator ->Requests -> Ready

Asking 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, requite the actual proper noun 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 Asking Group name

Navigation : Organization 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="Twenty - Alert Proper name"

Upload:

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

To become Alert proper name:

Warning Manger -> Warning -> 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 : Arrangement Administrator ->User ->Responsibility -> Ascertain

Course 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 -> Most oracle Applications -> Current Grade -> Form name

Grade Functions

Download :

FNDLOAD apps/<Pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <LDT_FILE_NAME>.ldt Part 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 Grade Function proper name

Navigation : Arrangement Administrator ->Awarding ->Office

Menus

Download :

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

To adhere a course function with an existing carte

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 : Arrangement Administrator ->Application ->Menu

FND Letters

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 become 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 past going to 'XML Publisher Responsibility'.

To get the Data Definition name

Navigation : XML Publisher Administrator -> Data definitions

To get the Tempalte proper noun

Navigation : XML Publisher Administrator -> Template

For any suggestion or issues with the higher up code, please leave your comments. I will endeavour to respond back as presently as possible

lambertprace1977.blogspot.com

Source: http://hiddenpriest.blogspot.com/2018/01/fndload-utility-in-oracle-apps.html

Share this post