FNDLOAD the complete

What FNDLOAD can be done?
These are the extensive list which can be done through FNDLOAD
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions/Personalizations
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Alerts
· Concurrent Manager Schedules


Some sample examples:

1.MENU:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct menu.ldt
MENU MENU_NAME=BOM_NAV

FUNCTION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct
function.ldt FUNCTION FUNCTION_NAME=INV_INVTTMTX

FORM:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form.ldt
FORM FORM_NAME=${shortname}

PERSONALIZATION:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct
formpersonalization.ldt FND_FORM_CUSTOM_RULES function_name=${shortname}

Upload
FNDLOAD apps/apps  0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XXPO_PURCHASEORDER.ldt 


PRINTER:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct
printer.ldt STYLE PRINTER_STYLE_NAME=${shortname}

CONCURRENT:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct
concprog.ldt PROGRAM CONCURRENT_PROGRAM_NAME=${shortname}

LOOKUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct
lookup.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE=${shortname}

RESPONSIBILITY:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/admin/import/afscursp.lct
responsible.ldt FND_RESPONSIBILITY RESP_KEY="${respkey}"

DESCFLEX:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
${shortname}_flex.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=${shortname}

KEYFLEX:
FNDLOAD apps/$PASSWD O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
keyflex.ldt KEY_FLEX
P_LEVEL='COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL: CVR_ALL:SEG_ALL'
APPLICATION_SHORT_NAME=${appshortname} ID_FLEX_CODE=MCAT
P_STRUCTURE_CODE=${shortname}

VALUE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct
valset.ldt VALUE_SET FLEX_VALUE_SET_NAME=${shortname}

PROFILE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct
profile.ldt PROFILE PROFILE_NAME=${shortname}

MESSAGE:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct
message.ldt FND_NEW_MESSAGES MESSAGE_NAME=${shortname}

REQUEST GROUP:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct
reqgrp.ldt REQUEST_GROUP REQUEST_GROUP_NAME=${shortname}

REQUEST SET:
OAUG Forum at COLLABORATE 08 Page 6
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct
rqstset.ldt REQ_SET APPLICATION_SHORT_NAME="FND"
REQUEST_SET_NAME=${shortname}

WEBADI:
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/admin/import/bnelay.lct
XX_C_O_F_T.ldt BNE_LAYOUTS LAYOUT_ASN="PER" LAYOUT_CODE="XX_C_O_F_T"

Blob:
With Release 12.1.1, FNDLOAD supports BLOB data (upload / download ) to better serve content-rich applications.
FNDLOAD apps/pwd 0 Y mode configfile datafile entity [ param ... ]

Some advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. There is nothing to worry to go to purchase because Investment = 0$
3. No learning curve. this is relief for developer and dba
4. Fully supported and recommended by Oracle
5. Capture the migrations in a file and use it during installations, clones etc. to migrate in batch
6. Pin-point when something happened and where (database) easily
7. Your AOL data migration process is now simplified and streamlined goal attained

Some disadvantages when using FNDLOAD
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. UPLOAD_MODE=REPLACE only for menus
3. No validation against migrating database/instance sensitive data

References:
Note: 274667.1 FNDLOAD Commands to Download Different Seed Data Types.
Note: 287417.1 Parameters Of Different Configuration Files To Download And Upload Seed Data Types.
Note: 256573.1 How To Download/Upload Descriptive Flexfield With Name $SRS$
EBS Release 11.5.10.2+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.0.4+ : Oracle Applications System Administrator's Guide - Configuration
EBS Release 12.1.3 : Oracle Applications System Administrator's Guide - Configuration
Customization Survival Guide: How to Use E-Business Utilities to Migrate Your Custom Code, Brad Simmons and Donna Campbell,
Los Alamos National Laboratory document
Tips About FNDLOAD [ID 735338.1]
Is It Possible To Use FNDLOAD To Migrate Configurations Or Data To Another Instance? [ID 1316916.1]
How To Use XDOLoader to Manage, Download and Upload Files? [ID 469585.1