Commonly-used FNDLOAD commands

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]
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s