Friday, July 29, 2016

Fnd_Load Scripts


Oracle Forms Personalization:
FNDLOAD APPS/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_FORM_PERS.ldt FND_FORM_CUSTOM_RULES function_name=AP_APXINWKB_BATCHES

FNDLOAD apps/<pwd> 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_FORM_PERS.ldt
Request Group:
FNDLOAD apps/<pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_GL_INQUIRY_REQ_GRP.ldt REQUEST_GROUP REQUEST_GROUP_NAME="Resp_grp_name" APPLICATION_SHORT_NAME="XX"

FNDLOAD apps/$apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct XX_GL_INQUIRY_REQ_GRP.ldt
Concurrent Program:
FNDLOAD apps/<pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XX"

FNDLOAD apps/$apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct XX_CP.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XX" CUSTOM_MODE=FORCE
RTF Template:
select * from xdo_lobs where lob_code = :l_lob_code and file_name like 'XX.rtf' and xdo_file_type = 'RTF'
java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD <pwd> -JDBC_CONNECTION '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxx.xxx.xxx)(PORT=xxxx))(CONNECT_DATA=(SERVICE_NAME=xxxx)))' -LOB_TYPE TEMPLATE_SOURCE -LOB_CODE <lob Code> -APPS_SHORT_NAME XX -LANGUAGE en -TERRITORY 00 -lct_FILE $XDO_TOP/patch/115/import/xdotmpl.lct -LOG_FILE $LOG_FILE_NAME

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD \
    -DB_USERNAME APPS \
    -DB_PASSWORD $apps_pwd \
    -JDBC_CONNECTION $jdbc \
    -APPS_SHORT_NAME XX \
    -LOB_TYPE TEMPLATE_SOURCE \
    -LOB_CODE <lob code> \
    -LANGUAGE en \
    -TERRITORY US \
    -XDO_FILE_TYPE RTF \
    -FILE_NAME XX.rtf \
    -CUSTOM_MODE FORCE



Request Set:
Request Set:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct Test_FNDRS_RS.ldt REQ_SET REQUEST_SET_NAME="FNDRSSUB1054"

FNDLOAD apps/$apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct Test_FNDRS_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

Request Set Link:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct Test_FNDRS_LINK.ldt REQ_SET_LINKS REQUEST_SET_NAME="FNDRSSUB1054"

FNDLOAD apps/$apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct Test_FNDRS_LINK.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
Alert:
FNDLOAD apps/$apps_pwd 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_ALERT.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XX ALERT_NAME="XX - Alert Name"

FNDLOAD apps/$apps_pwd 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_ALERT.ldt CUSTOM_MODE=FORCE 

For Web ADI:
Integrator:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct XX_LDT_FILE_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN=XX INTEGRATOR_CODE=<integrator Code>

FNDLOAD apps/$apps_pwd  0 Y UPLOAD  $BNE_TOP/patch/115/import/bneint.lct XX_LDT_FILE_INTG.ldt
Download Layout: 
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct XX_LDT_FILE_LAYOUT.ldt BNE_LAYOUTS LAYOUT_ASN=XX LAYOUT_CODE=<Layout Name>

FNDLOAD $apps_user/$apps_pwd  0 Y UPLOAD  $BNE_TOP/patch/115/import/bnelay.lct XX_LDT_FILE_LAYOUT.ldt
Download Contents:  
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct XXOMG_CONTENT.ldt BNE_CONTENTS CONTENT_ASN=XX CONTENT_CODE=<Content code>

FNDLOAD $apps_user/$apps_pwd  0 Y UPLOAD  $BNE_TOP/patch/115/import/bnecont.lct XXOMG_CONTENT.ldt

Download mappings:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnemap.lct XX_LDT_FILE_MAP.ldt BNE_MAPPINGS MAPPING_ASN=XX MAPPING_CODE=MAP_KEY1

FNDLOAD $apps_user/$apps_pwd  0 Y UPLOAD  $BNE_TOP/patch/115/import/bnemap.lct XX_LDT_FILE_MAP.ldt
Lookup:
FNDLOAD apps/<pwd> O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_INDICATOR_LK.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=XX LOOKUP_TYPE=XX_INDICATOR_LK

FNDLOAD $apps_user/$apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct XX_INDICATOR_LK.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE
Function:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_LDT_FILE_ADI.ldt FUNCTION FUNCTION_NAME=XX_LDT_FILE_ADI 
FNDLOAD $apps_user/$apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_LDT_FILE_ADI.ldt

Menu:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_LDT_FILE_MENU.ldt MENU MENU_NAME=XX_OBI_SALES_UPLOAD

FNDLOAD $apps_user/$apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_LDT_FILE_MENU.ldt
Responsibility:
FNDLOAD apps/<pwd> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_LDT_FILE_RESP.ldt FND_RESPONSIBILITY RESP_KEY=XX_OBI_SALES_UPLOAD

FNDLOAD $apps_user/$apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct  XX_LDT_FILE_RESP.ldt

No comments:

Post a Comment