Tuesday, January 14, 2014

FNDLOAD Commands to download and upload various application objects

FNDLOAD Commands

FNDLOAD Commands are used to extract objects which is at application level. By using these commands you can extract those in files from one instance and upload it to another instance by using s same command but by changing paramters.

These commands are widely used for migration purposes which remove human intervention and typo mistakes by directly downloading into file and uploding same into another enviornament.

FNDLOAD commands with download paramter-

Printer Styles
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=”printer style name”

Lookups
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=”FND”
LOOKUP_TYPE=”lookup name”

Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/<password> O 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=”FND” DESCRIPTIVE_FLEXFIELD_NAME=”desc flex name” P_CONTEXT_CODE=”context name”

Key Flexfield Structures
FNDLOAD apps/<password> O 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=”FND” ID_FLEX_CODE=”key flex code” P_STRUCTURE_CODE=”structure name”

Concurrent Programs
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=”FND” CONCURRENT_PROGRAM_NAME=”concurrent name”

Value Sets
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=”value set name”

Value Sets with values
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME=”value set name”

Profile Options
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME=”profile option” APPLICATION_SHORT_NAME=”FND”

Request Groups
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME=”request group” APPLICATION_SHORT_NAME=”FND”

Request Sets
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME=”FND” REQUEST_SET_NAME=”request set”

FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET REQUEST_SET_NAME=”request set”

FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET_LINKS REQUEST_SET_NAME=”request set”

Responsibilities
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY=”responsibility”

Menus
FNDLOAD apps/<password> O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME=”menu_name”

Forms Personalization
FNDLOAD apps/<password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name=FUNCTION_NAME

FNDLOAD apps/pNUWdFy2 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XXCMST_MSCFNSCW.ldt FND_FORM_CUSTOM_RULES form_name=MSCFNSCW


FNDLOAD commands with upload paramter-

UPLOAD command is same for all except replacing the .lct and passing any extra parameters if you want to pass

FNDLOAD apps/<password> 0 Y UPLOAD $FND_TOP/patch/115/import/corresponding.lct upload_file.ldt

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

2 comments:

  1. Need FNDLOAD command for Element Set

    ReplyDelete
  2. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete