Monday, January 31, 2011

FNDLOAD Scripts for AOL Objects

Comment: Use FNDLOAD to Download and Upload data into a new instance.
----------------------------------------------------------------------------------

Concurrent Program:
----------------------
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct .ldt PROGRAM CONCURRENT_PROGRAM_NAME='' APPLICATION_SHORT_NAME='BOLINF'

Concurrent Program Upload
---------------------------
FNDLOAD $APPS_ID 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $PATH/.ldt


DOWNLOAD Report
----------------
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct $XBOL_TOP/patch/115/import/US/<..GECF_FN..>.ldt PROGRAM CONCURRENT_PROGRAM_NAME=<..GECF_FN..>

UPLOAD Report
-------------
FNDLOAD 0 Y UPLOAD PARTIAL $FND_TOP/patch/115/import/afcpprog.lct <$path\filename>

DOWNLOAD Spreadtable Grid
-------------------------

FNDLOAD apps/or4cle50 0 Y DOWNLOAD $JTF_TOP/patch/115/import/jtfgrid.lct $XBOL_TOP/patch/115/import/STDOKLTRX.ldt JTF_GRID_DATASOURCES GRID_DATASOURCE_NAME=<..SPD_NAME..>

UPLOAD Spreadtable Grid
-----------------------
FNDLOAD apps/apps 0 Y UPLOAD $JTF_TOP/patch/115/import/jtfgrid.lct $XBOL_TOP/patch/115/import/US/<..GECF_FN..>.ldt

FNDLOAD for DESC_FLEX - Context specific
----------------------------------------

FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct $PATH/<..GECF_FN..>.ldt DESC_FLEX APPLICATION_SHORT_NAME = 'AR%' DESCRIPTIVE_FLEXFIELD_NAME=<..DESC_NAME..> P_CONTEXT_CODE=XYZ

Request Set Download
--------------------
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct $PATH/<..GECF_FN..>.ldt REQ_SET REQUEST_SET_NAME=""

Request Set Upload
------------------
FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct $PATH/<..GECF_FN..>.ldt

Request Set Stage Links
-------------------------
FNDLOAD sqllogon 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct $PATH/<..GECF_FN..>.ldt REQ_SET_LINKS REQUEST_SET_NAME="<>"

Upload Request Set Stage links information
-------------------------------------------
FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct $PATH/<..GECF_FN..>.ldt
*** All the required Concurrent Program definitions should exist before loading the Request Set on the Target Instance. ***

Profile Upload
---------------
FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/admin/import/afscprof.lct $PATH/<..GECF_FN..>.plt

Profile Download
---------------
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="prod"

Responsibility Download
----------------------
FNDLOAD apps/ 0 Y DOWNLOAD_PARTIAL @FND:patch/115/import/afscursp.lct $PATH/<..GECF_FN..>.ldt FND_RESPONSIBILITY "responsibility name".

User Upload
-------------
FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/admin/import/afscursp.lct $PATH/<..GECF_FN..>.ldt

Menu Upload
------------
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct $XBOL_TOP/patch/115/import/.ldt MENU MENU_NAME=<..Menu_Name..>

Form Register Download
----------------------
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct $XBOL_TOP/patch/115/import/.ldt FORM FORM_NAME=GECF_OKLCSHDR

Form Register Upload
--------------------
FNDLOAD apps/ 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $XBOL_TOP/patch/115/import/.ldt FORM FORM_NAME=<..FORM_NAME..>

Form Function Register Download
-------------------------------
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct $XBOL_TOP/patch/115/import/.ldt FUNCTION FUNCTION_NAME=<..FUNC_NAME..>

Form Function Register Upload
-------------------------------
FNDLOAD apps/ 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $XBOL_TOP/patch/115/import/<..GECF_FN..>.ldt FUNCTION FUNCTION_NAME=<..FUNC_NAME..>

Form Function Register Upload With force Option
-----------------------------------------------

FNDLOAD $APPS_ID 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $<..FUNCTION_FILE_NAME..>.ldt FUNCTION FUNCTION_NAME=<..FUNCTION_NAME..> - WARNINGS=TRUE CUSTOM_MODE=FORCE

Workflow Event Download
-----------------------
jre oracle.apps.fnd.wf.WFXLoad -d apps or4cle50 mmfolmdb01.mmf.capital.ge.com:1553:mmfd50 thin US GECF_GAP2945839_LTR_E.wfx EVENTS oracle.apps.wf.gecf.ltr

Workflow Subscription Download
------------------------------
jre oracle.apps.fnd.wf.WFXLoad -d apps or4cle50 mmfolmdb01.mmf.capital.ge.com:1553:mmfd50 thin US GECF_GAP2945839_LTR_S.wfx SUBSCRIPTIONS oracle.apps.wf.gecf

Printer Styles
-----------------------
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

Lookups
-----------------------
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="prod"
LOOKUP_TYPE="lookup name"

FNDLOAD $APPS_ID O Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/aflvmlu.lct $XBOL_TOP/bin/XXMI_UTL_CDU_FLATCH_CATEGORY.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="XBOL" LOOKUP_TYPE="XXMI_FILE_ATTACH_CATEGORY" - CUSTOM_MODE=FORCE

Descriptive Flexfield with all of specific Contexts
----------------------------------------------
FNDLOAD apps/apps@seed115 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="prod" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

Key Flexfield Structures
-----------------------
FNDLOAD apps/apps@seed115 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="prod" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

Value Sets
-----------------------
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

Value Sets with values
-----------------------
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

Request Groups
-----------------------
FNDLOAD apps/apps\@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="prod"

Responsibilities
-----------------------
FNDLOAD apps/apps\@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

Menus
-----------------------
FNDLOAD apps/apps\@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"

Others:

FNDLOAD commands for NLS Languages
---------------------------------

export NLS_LANG="DUTCH_THE NETHERLANDS.WE8ISO8859P1"
FNDLOAD APPS/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct \APACCENG.ldt PROGRAM CONCURRENT_PROGRAM_NAME=APACCENG APPLICATION_SHORT_NAME=SQLAP


FNDLOAD / 0 Y UPLOAD \- UPLOAD_MODE=NLS CUSTOM_MODE=FORCE WARNINGS=TRUE

--------------------------------------------------------------------------------


FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_EDI824_OUT.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCPEDI824

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_FILEARC.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCPARC

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXJCP_GL_ACCT_IN_REQ.ldt REQ_SET REQUEST_SET_NAME=FNDRSSUB725

FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXJCP_GL_ACCT_IN_RLINK.ldt REQ_SET_LINKS REQUEST_SET_NAME=FNDRSSUB725

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_EDI824_OUT.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCPEDI824

FNDLOAD FOR DOWNLOAD OF MESAGES

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXJCP_EDI824_REJIQRY_OBJNOT_MSG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=POS MESSAGE_NAME=XXJCP_REJIQRY_OBJ_NOT_FOUND

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_EDI824_REJIQRY_OBJNOT_MSG.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXJCP_EDI824_REJIQRY_PROFILE_MSG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=POS MESSAGE_NAME=XXJCP_REJIQRY_PROFILE_NOTSET

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_EDI824_REJIQRY_PROFILE_MSG.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXJCP_REJIQRY_VIEW_NOTFOUND_MSG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=POS MESSAGE_NAME=XXJCP_REJIQRY_VIEW_NOTFOUND

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_REJIQRY_VIEW_NOTFOUND_MSG.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct XXJCP_EDI824_REJIQRY_OBJECT_MSG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME=POS MESSAGE_NAME=XXJCP_REJIQRY_OBJECT_NOTFOUND

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_EDI824_REJIQRY_OBJECT_MSG.ldt - CUSTOM_MODE=FORCE

FNDLOAD FOR DOWNLOAD OF FUNCTIONS

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_EDI824_REJIQRY_FUNCT.ldt FUNCTION FUNCTION_NAME=XXJCP_REJINQRY_VIEW - CUSTOM_MODE=FORCE


FNDLOAD APPS/APPS 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_EDI824_REJIQRY_FUNCT.ldt FUNCTION FUNCTION_NAME='XXJCP_REJINQRY_VIEW'

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_EDI824_REJIQRY_MENU.ldt MENU MENU_NAME=POS_ACCOUNT USER_MENU_NAME="Account" DESCRIPTION="Account" PROMPT="View Rejected Invoice" SUBMENU = "" FUNCTION =XXJCP_REJINQRY_VIEW - CUTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_EDI824_REJIQRY_MENU.ldt MENU PROMPT="View Rejected Invoice" SUBMENU = "" FUNCTION =XXJCP_REJINQRY_VIEW - CUTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_EDI824_REJIQRY_MENU.ldt MENU PARENT_MENU_NAME=POS_ACCOUNT FUNCTION_NAME=XXJCP_REJINQRY_VIEW - CUTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y UPLOAD_PARTIAL$FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_EDI824_REJIQRY_MAIN_MENU.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_EDI824_REJIQRY_MAIN_MENU.ldt MENU PARENT_MENU_NAME=POS_ACCOUNT - CUTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/iSPReject_Inqry/XXJCP_EDI824_REJIQRY_MAIN_MENU.ldt MENU PARENT_MENU_NAME=POS_ACCOUNT CUSTOM_MODE=FORCE

$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afsload.lct PWRB_LITIGATION_MENU.ldt MENU MENU_NAME="WRB_PWD_NAVIGATE_GUI_G"

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_TXN_HIST_FORM.ldt FORM APPLICATION_SHORT_NAME=AP FORM_NAME=XXJCPTXHT

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_TXN_HIST_FUNC.ldt FUNCTION FUNCTION_NAME=XXJCP_AP_TXN_HIST - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_TXN_HIST_SUBMENU.ldt MENU MENU_NAME=JCP_TXNHIST_SUBMENU

FNDLOAD APPS/ASK4APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XXJCP_TXN_HIST_MENU.ldt MENU MENU_NAME=JCP_CUSTOM_DEVELOPMENT

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/transaction_hist/XXJCP_TXN_HIST_FORM.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/transaction_hist/XXJCP_TXN_HIST_FUNC.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/ASK4APPS 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/transaction_hist/XXJCP_TXN_HIST_MENU.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/ASK4APPS 0 Y UPLOAD_PARTIAL $FND_TOP/patch/115/import/afsload.lct $XXJCP_TOP/install/transaction_hist/XXJCP_TXN_HIST_MENU.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_TXNHIST_IMP_PROG.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCPTXNHISTIMP

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_TXNHIST_PURGE_PROG.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCPTXNHISTPURGE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXJCP_TXNHIST_IMP_REQSET.ldt REQ_SET REQUEST_SET_NAME=FNDRSSUB752 APPLICATION_SHORT_NAME=XXJCP

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XXJCP_TXNHIST_IMP_REQSET_LINK.ldt REQ_SET_LINKS REQUEST_SET_NAME=FNDRSSUB752 APPLICATION_SHORT_NAME=XXJCP

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_TXNHIST_IMP_PROG.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_TXNHIST_PURGE_PROG.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XXJCP_TXNHIST_IMP_REQSET.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct XXJCP_TXNHIST_IMP_REQSET_LINK.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_EDITP_IN.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCPEDITPIN

FNDLOAD APPS/APPS O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XXJCP_NONPOINV_FLEXVAL_SET.ldt VALUE_SET FLEX_VALUE_SET_NAME="JCP_NON_STORE_LOCATIONS"

FNDLOAD APPS/APPS O Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XXJCP_NONPOINV_FLEXVAL_SET.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/APPS O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct XXJCP_NONPOINV_STORE_PROFILE.ldt PROFILE PROFILE_NAME="JCP_STORE_FENCE" APPLICATION_SHORT_NAME="XXJCP"

FNDLOAD APPS/APPS O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct XXJCP_NONPOINV_STORE_PROFILE.ldt - CUSTOM_MODE=FORCE

FNDLOAD APPS/ask4apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_MCH_CALC_DUE_DATE.ldt PROGRAM CONCURRENT_PROGRAM_NAME=XXJCP_MCH_CALC_DUE_DATE

FNDLOAD APPS/ask4apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XXJCP_MCH_CALC_DUE_DATE.ldt - CUSTOM_MODE=FORCE

2 comments:

Mark Mestetskiy said...

did you try MigrationLogiK - GUI for FNDLOAD

GAMESH TAWADE said...

One of the best product I ve ever purchased from would highly recommend you to go for this product best product to make you laugh and relax thank you so mach.
Read the article