最全FNDLOAD脚本大全

-- 并发请求( 含可执行、值集、弹性域、并发 )

FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct $CUX_TOP/import/CUXTEST_PROG.ldt PROGRAM APPLICATION_SHORT_NAME="CUX" CONCURRENT_PROGRAM_NAME="CUXTEST"

FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $CUX_TOP/import/CUXTEST_PROG.ldt

-- 功能

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct $CUX_TOP/import/CUXTEST_FUN.ldt FUNCTION FUNC_APP_SHORT_NAME="CUX" FUNCTION_NAME="CUXTEST"

FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.ldt $CUX_TOP/import/CUXTEST_FUN.ldt

-- 菜单(默认菜单下所有子菜单和功能)

FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct $CUX_TOP/import/CUXTEST_MENU.ldt MENU MENU_APP_SHORT_NAME= "CUX" MENU_NAME="CUXTEST"

FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $CUX_TOP/import/CUXTEST_MENU.ldt

-- LOOKUP CODE

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct $CUX_TOP/import/CUXTEST_LK.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME ='CUX' LOOKUP_TYPE="CUXTEST"

FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct $CUX_TOP/import/CUXTEST_LK.ldt

-- 消息

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct $CUX_TOP/import/CUXTEST_MSG.ldt FND_NEW_MESSAGES APPLICATION_SHORT_NAME='CUX' MESSAGE_NAME="CUXTEST"

FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct $CUX_TOP/import/CUXTEST_MSG.ldt

-- 配置文件

FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct $CUX_TOP/import/CUXTEST_PRO.ldt PROFILE APPLICATION_SHORT_NAME="CUX" PROFILE_NAME="CUXTEST"

FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct $CUX_TOP/import/CUXTEST_PRO.ldt

-- Form个性化

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct $CUX_TOP/import/CUXTEST_CUS.ldt FND_FORM_CUSTOM_RULES APPLICATION_SHORT_NAME="CUX" function_name="CUXTEST"

FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct $CUX_TOP/import/CUXTEST_CUS.ldt

-- 附件

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct $CUX_TOP/import/CUXTEST_ATT.ldt  FND_ATTACHMENT_FUNCTIONS APPLICATION_SHORT_NAME="CUX" FUNCTION_NAME=”CUXTEST”

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afattach.lct $CUX_TOP/import/CUXTEST_ATT.ldt

-- 值集和值

FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct $CUX_TOP/import/CUXTEST_VASET.ldt VALUE_SET APPLICATION_SHORT_NAME="CUX" FLEX_VALUE_SET_NAME=”CUXTEST”

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct $CUX_TOP/import/CUXTEST_VASET.ldt

-- 职责

FNDLOAD apps/apps_pwd O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct $CUX_TOP/import/CUXTEST_RESP.ldt FND_RESPONSIBILITY RESP_KEY="CUXTEST"

FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct $CUX_TOP/import/CUXTEST_RESP.ldt

--请求组

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct CE_REQUEST_ALL.ldt REQUEST_GROUP APPLICATION_SHORT_NAME="CUX" REQUEST_GROUP_NAME="CE_REQUEST_ALL"

FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afcpreqg.lct $CUX_TOP/import/ldtscripts/CE_REQUEST_ALL.ldt

-- 数据定义

FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct  $CUX_TOP/import/CUXTEST_XDO.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="CUX" DATA_SOURCE_CODE="CUXTEST"

FNDLOAD apps/apps_pwd 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct $CUX_TOP/import/CUXTEST_XDO.ldt

-- 模板

-- 先将rtf模板上传到服务器 $CUX_TOP/import/

-- 其中 apps apps_pwd为db user/password ; host:port:sid 需替换为tns中对应的数据;

java oracle.apps.xdo.oa.util.XDOLoader UPLOAD -DB_USERNAME apps -DB_PASSWORD apps_pwd -JDBC_CONNECTION  HOST:PORT:SID -LOB_TYPE TEMPLATE -APPS_SHORT_NAME "CUX" -LOB_CODE "CUXTEST" -LANGUAGE zh -XDO_FILE_TYPE RTF -FILE_NAME $CUX_TOP/import/CUXTEST.rtf