Using FNDLOAD with examples

So, here’s my examples on how to use FNDLOAD…
FND Messages
Downloading one message:

FNDLOAD apps/password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afmdmsg.lct
  filename.ldt
  FND_NEW_MESSAGES
  APPLICATION_SHORT_NAME='short name'
  MESSAGE_NAME=message name

Example to extract one specific HR message:
  FNDLOAD apps/apps 0 Y DOWNLOAD
    $FND_TOP/patch/115/import/afmdmsg.lct
    CAC_SR_HIER_ENTRY_DATE_ERROR.ldt
    FND_NEW_MESSAGES
    APPLICATION_SHORT_NAME='PER'
    MESSAGE_NAME=CAC_SR_HIER_ENTRY_DATE_ERROR

Downloading all the messages for the same application:

FNDLOAD apps/password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afmdmsg.lct 
  filename.ldt
  FND_NEW_MESSAGES
  APPLICATION_SHORT_NAME='short name'

Example to extract all HR messages:
  FNDLOAD apps/apps 0 Y DOWNLOAD
    $FND_TOP/patch/115/import/afmdmsg.lct
    ALL_HR_MESSAGES.ldt
    FND_NEW_MESSAGES
    APPLICATION_SHORT_NAME='PER'

Uploading FND messages from a file:

FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct filename.ldt

Menus
Downloading a menu:

FNDLOAD apps/password O Y DOWNLOAD
  $FND_TOP/patch/115/import/afsload.lct filename.ldt
  MENU MENU_NAME="menu name" 

 Example to extract Workflow Administrator (New) Menu:
  FNDLOAD apps/apps O Y DOWNLOAD
    $FND_TOP/patch/115/import/afsload.lct FND_WFADMIN_NEW.ldt
    MENU MENU_NAME="FND_WFADMIN_NEW"

Note that since Oracle Menus are not attached to applications, there is no need to include an application short name.

Uploading the menu:

FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct filename.ldt

Descriptive Flexfields
Downloading:

FNDLOAD apps/password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afffload.lct
  filename.ldt
  DESC_FLEX
  APPLICATION_SHORT_NAME='short name'
  DESCRIPTIVE_FLEXFIELD_NAME='flexfield name' 

 Example to download person DFF:
  FNDLOAD apps/apps 0 Y DOWNLOAD
    $FND_TOP/patch/115/import/afffload.lct
    PER_PEOPLE_DFF.ldt
    DESC_FLEX
    APPLICATION_SHORT_NAME='PER'
    DESCRIPTIVE_FLEXFIELD_NAME='PER_PEOPLE'

You can find the name of the descriptive flexfield from the table name by running the following code:

SELECT application_id
,      descriptive_flexfield_name
,      application_table_name
FROM   fnd_descriptive_flexs_vl
WHERE  application_table_name = 'table name'
ORDER BY application_table_name;

Example:
  SELECT application_id
  ,      descriptive_flexfield_name
  ,      application_table_name
  FROM   fnd_descriptive_flexs_vl
  WHERE  application_table_name LIKE 'PER%PEOPLE%'
  ORDER BY application_table_name;

Uploading:

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

Concurrent Programs
Downloading a program:

FNDLOAD apps/password O Y DOWNLOAD
  $FND_TOP/patch/115/import/afcpprog.lct
  filename.ldt
  PROGRAM
  APPLICATION_SHORT_NAME="short name"
  CONCURRENT_PROGRAM_NAME="program name"

Example to download HR allocate checklist process:
  FNDLOAD apps/apps O Y DOWNLOAD
  $FND_TOP/patch/115/import/afcpprog.lct
  ALLOCATECKL.ldt
  PROGRAM
  APPLICATION_SHORT_NAME="PER"
  CONCURRENT_PROGRAM_NAME="ALLOCATECKL"

Uploading the program:

FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct filename.ldt

Request Groups
Downloading a request group:

FNDLOAD apps/password O Y DOWNLOAD
  $FND_TOP/patch/115/import/afcpreqg.lct
  filename.ldt
  REQUEST_GROUP
  REQUEST_GROUP_NAME="request group name"
  APPLICATION_SHORT_NAME="short name"

Example to download Workflow Administrator request group:
  FNDLOAD apps/apps O Y DOWNLOAD
    $FND_TOP/patch/115/import/afcpreqg.lct
    Workflow_Admin_Request_Group.ldt
    REQUEST_GROUP
    REQUEST_GROUP_NAME="Workflow Administrator"
    APPLICATION_SHORT_NAME="FND"

Uploading the request group:

FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct filename.ldt

Lookup Values

Downloading lookup values:

FNDLOAD apps/password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/aflvmlu.lct
  filename.ldt
  FND_LOOKUP_TYPE
  APPLICATION_SHORT_NAME ='short name'
  LOOKUP_TYPE="lookup type"

Example to download lookup values for Workflow Signature Policy:
  FNDLOAD apps/apps O Y DOWNLOAD
    $FND_TOP/patch/115/import/aflvmlu.lct
    WF_SIG_POLICY.ldt
    FND_LOOKUP_TYPE
    APPLICATION_SHORT_NAME ='FND'
    LOOKUP_TYPE="WF_SIG_POLICY"

Uploading:

FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct filename.ldt

User definitions
Downloading a user:

FNDLOAD apps/password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/afscursp.lct
  filename.ldt
  FND_USER USER_NAME='user name'

Example to extract my user from my environment:
  FNDLOAD apps/apps 0 Y DOWNLOAD
    $FND_TOP/patch/115/import/afscursp.lct
    USER_SEARLEM.ldt
    FND_USER USER_NAME='SEARLEM'

Uploading the user file:

FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct filename.ldt

Note:-
Extracting a user using this method will also extract the responsibility definitions and assign them to the user. When the user logs into the new environment, they will be prompted to change their password.



Profile Options
Downloading profile option values:

FNDLOAD apps/password O Y DOWNLOAD
  $FND_TOP/patch/115/import/afscprof.lct
  filename.ldt
  PROFILE
  PROFILE_NAME="profile name"
  APPLICATION_SHORT_NAME="short name"

Example to extract value of FND: Diagnostics:
  FNDLOAD apps/apps O Y DOWNLOAD
  $FND_TOP/patch/115/import/afscprof.lct
  FND_DIAGNOSTICS.ldt
  PROFILE
  PROFILE_NAME="FND_DIAGNOSTICS"
  APPLICATION_SHORT_NAME="FND"

Note that we pass in the short name of profile option, not the user profile option name. You can find the short name from the user profile option name by running the following SQL:

SELECT application_id
,      profile_option_name
,      profile_option_id
,      user_profile_option_name
FROM   fnd_profile_options_vl
WHERE  user_profile_option_name LIKE '%Diagn%'
ORDER BY profile_option_name;

Uploading:

FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct filename.ldt

Responsibilities
Downloading a responsibility:

FNDLOAD apps/password O Y DOWNLOAD
  $FND_TOP/patch/115/import/afscursp.lct
  filename.ldt
  FND_RESPONSIBILITY
  RESP_KEY="responsibility"

Example to download Application Developer responsibility:
  FNDLOAD apps/apps O Y DOWNLOAD
    $FND_TOP/patch/115/import/afscursp.lct
    APPLDEV.ldt
    FND_RESPONSIBILITY
    RESP_KEY="APPLICATION_DEVELOPER"

Uploading:

FNDLOAD apps/password O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct filename.ldt

Forms Personalizations
Downloading personalizations:

FNDLOAD apps/password 0 Y DOWNLOAD
  $FND_TOP/patch/115/import/affrmcus.lct
  filename.ldt
  FND_FORM_CUSTOM_RULES
  function_name="function name"

Example to download personalizations to the Document Sequences form:
  FNDLOAD apps/apps 0 Y DOWNLOAD
    $FND_TOP/patch/115/import/affrmcus.lct
    FND_FNDSNDSQ.ldt
    FND_FORM_CUSTOM_RULES
    function_name="FND_FNDSNDSQ"

Uploading:

FNDLOAD apps/password 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct filename.ldt