Monday, May 25, 2009

Most 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]"

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="[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)

AME's Entity .lct File Name
Transaction Types amescvar.lct
Attributes amesmatt.lct
Conditions amesconk.lct
Action Type Configurations amesaatc.lct
Approver Groups amesappg.lct
Rules amesrulk.lct
Rule Action amesactu.lct
Attribute Usage amesmatr.lct
Approver Group Configurations amesaagc.lct

25- Work Flows

Download :
WFLOAD [apps/pwd] 0 Y DOWNLOAD [filepath] [[item type]]

Upload
WFLOAD [apps/pwd] 0 Y UPLOAD [filepath]

Upload Command

FNDLOAD apps/ [apps_pwd]@[db_sid] 0 Y UPLOAD [.lct file path] [.ldt file name]

Eg: FNDLOAD apps/ [apps_pwd]@[db_sid] 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct messages.ldt

No comments:

Post a Comment