1 – Alerts
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct file_name.ldt ALR_ALERTS APPLICATION_SHORT_NAME="PER" ALERT_NAME="[Alert Name]"
2 – Lookups
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="PER" LOOKUP_TYPE="[lookup type code]"
3 – Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL" APPLICATION_SHORT_NAME="PER" DESCRIPTIVE_FLEXFIELD_NAME="[descriptive flex field name]" P_CONTEXT_CODE="[Context code]"
or
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="FND_FLEX_VALUES" DESCRIPTIVE_FLEX_CONTEXT_CODE="[CONTEXT_CODE]" P_LEVEL="COL_ALL:REF_ALL:CTX_ONE:SEG_ALL"
4 – Key Flexfield Structures
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct 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="PER" ID_FLEX_CODE=" P_STRUCTURE_CODE="[structure code]"
5 – Concurrent Programs
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="PER" CONCURRENT_PROGRAM_NAME="[concurrent program short name]"
6 – Value Sets
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="[value set name]"
7 – Profile Options
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="PER_BUSINESS_GROUP_ID"
8 – Request Groups
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="[Request group Name]" APPLICATION_SHORT_NAME="PER"
9 – Request Sets
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="PER" REQUEST_SET_NAME="[request set name]"
10 – Responsibilities
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="[Responsibility key]"
11 – Menus
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="[menu name]"
12 – Balances
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $PAY_TOP/patch/115/import/paydefbalance.lct file_name.ldt DEFINED_BALANCES BALANCE_NAME="[balance name]" BALANCE_DIMENSION="[bal dimention]" LEGISLATION_CODE=US
13-Messages
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct file_name.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME="PER" MESSAGE_NAME="[Message Name]"
14 – WEB ADI integrator
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneint.lct file_name.ldt BNE_INTEGRATORS INTEGRATOR_ASN="PER" INTEGRATOR_CODE="[Integrator code]"
15 – Web ADI contents
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct file_name.ldt BNE_CONTENTS CONTENT_ASN="PER" CONTENT_CODE="[Content code]"
16 – Web ADI mappings
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnemap.lct file_name.ldt BNE_MAPPINGS MAPPING_ASN="PER" MAPPING_CODE="[mapping code]"
17 – Web ADI layout
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct file_name.ldt BNE_LAYOUTS LAYOUT_ASN="PER" LAYOUT_CODE="[layout code]"
18 – Web ADI parameter list
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneparamlist.lct file_name.ldt BNE_PARAM_LISTS PARAM_LIST_ASN="PER" PARAM_LIST_CODE="[parameterlist code]"
19 – WEB ADI component
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecomp.lct file_name.ldt BNE_COMPONENTS COMPONENT_ASN="PER" COMPONENT_CODE="[Component code]"
20 – Functions
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FUNCTION FUNCTION_NAME="[Function code]"
21 – Printer Styles
FNDLOAD apps/[pwd]@[DB] 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"
22 – USER
FNDLOAD apps/apps@ktplr12 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct usr.ldt FND_USER USER_NAME="XXHR"
23 – XML Publisher Data Definition and Templates
FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct template.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=PER DATA_SOURCE_CODE=[DATADEFINITIONCODE]
The Above command downloads all the templates defined for this Particular Data Definition. For a particular template to be downloaded use
FNDLOAD apps/apps 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XMLPData.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME=[CUSTOM] DATA_SOURCE_CODE=[DATADEFSHORTCODE] TMPL_APP_SHORT_NAME=[CUSTOM] TEMPLATE_CODE=[TEMPLATECODE]
24 – AME Entities($AME_TOP /patch/115/import)
Note: Static Approver Groups, and AME Rules which use them, are specific to an instance, and cannot therefore be migrated using FNDLOAD.
AME Entity .lct File Name ================================= ================================= Transaction Types amescvar.lct Attributes amesmatt.lct Conditions amesconk.lct Action Type Configurations amesaatc.lct Approval Groups amesappg.lct (Dynamic Approval Groups only) Rules amesrulk.lct Rule Action amesactu.lct Attribute Usage amesmatr.lct Approver Group Configurations amesaagc.lct
For example…
Rules
FNDLOAD apps/[apps_pwd]@[db_sid] 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesrulk.lct AME_rule.ldt AME_RULES RULE_KEY=454461192:10044 TRANSACTION_TYPE_ID=APEXP APPLICATION_SHORT_NAME=SQLAP;
Rule Actions
FNDLOAD apps/RO_LONDON 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesactu.lct test4.ldt AME_ACTION_USAGES RULE_KEY=3232937504:10120 TRANSACTION_TYPE_ID=APEXP APPLICATION_SHORT_NAME=SQLAP;
Conditions
FNDLOAD apps/[apps_pwd]@[db_sid] 0 Y DOWNLOAD $AME_TOP/patch/115/import/amesconk.lct AME_Condition.ldt AME_CONDITIONS CONDITION_KEY=454461192:10066 TRANSACTION_TYPE_ID=APEXP APPLICATION_SHORT_NAME=SQLAP;
25 – Core Forms Personalizations
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name="[function_name]"
To download all personalizations, omit the function_name= clause.
26 – FNDLOAD Upload Commands
FNDLOAD apps/ [apps_pwd]@[db_sid] 0 Y UPLOAD [.lct file path] [.ldt file name] [CUSTOM_MODE=FORCE]
Eg:
FNDLOAD apps/ [apps_pwd]@[db_sid] 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct messages.ldt
27 – Work Flows
Download :
WFLOAD [apps/pwd] 0 Y DOWNLOAD [filepath] [[item type]]
Upload
WFLOAD [apps/pwd] 0 Y UPLOAD [filepath]