【FNDLOAD】系统数据迁移

93 阅读 0 评论 62 点赞

我是靠谱客的博主开放鼠标，最近开发中收集的这篇文章主要介绍【FNDLOAD】系统数据迁移，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

switch language

NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
export NLS_LANG
 
NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
export NLS_LANG

--【快码】
#download
FNDLOAD apps/appsapps 0 Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct $BITC_TOP/install/hqc/20210204/BITC_CUST_ORDER_HEADER_STATUS.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="BITC" LOOKUP_TYPE="BITC_CUST_ORDER_HEADER_STATUS"
#upload
FNDLOAD apps/appsapps 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct $BITC_TOP/install/hqc/20210204/BITC_CUST_ORDER_HEADER_STATUS.ldt - CUSTOM_MODE=FORCE

--【并发请求】（含可执行、值集、弹性域、并发程序）
#download
FNDLOAD apps/appsapps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct $BITC_TOP/install/hqc/20210204/BITCCUSTORDRES.ldt PROGRAM APPLICATION_SHORT_NAME="BITC" CONCURRENT_PROGRAM_NAME="BITCCUSTORDRES"
#upload
FNDLOAD apps/appsapps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $BITC_TOP/install/hqc/20210204/BITCCUSTORDRES.ldt - CUSTOM_MODE=FORCE

--【值集】
#download
FNDLOAD apps/appsapps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct $BITC_TOP/install/hqc/20210204/BITC_CUST_ORDER_AUTHORITY.ldt VALUE_SET FLEX_VALUE_SET_NAME="BITC_CUST_ORDER_AUTHORITY"
#upload
FNDLOAD apps/appsapps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct $BITC_TOP/install/hqc/20210204/BITC_CUST_ORDER_AUTHORITY.ldt - CUSTOM_MODE=FORCE

--【Form】
#download
$FND_TOP/bin/FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt FORM FORM_NAME="FORM_NAME"
#upload
$FND_TOP/bin/FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct XX_CUSTOM_FRM.ldt - WARNING=YES UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

--【功能】
#download
FNDLOAD apps/apps 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"
#upload
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.ldt $CUX_TOP/import/CUXTEST_FUN.ldt

--【菜单】(默认菜单下所有子菜单和功能)
#download
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"
#upload
FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $CUX_TOP/import/CUXTEST_MENU.ldt

--【请求集】
#download
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct XX_CUSTOM_RS.ldt REQ_SET REQUEST_SET_NAME='REQUEST_SET_NAME'
#upload
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afcprset.lct  XX_CUSTOM_RS.ldt UPLOAD_MODE=REPLACE CUSTOM_MODE=FORCE

--【配置文件】
#download
FNDLOAD apps/appsapps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct $BITC_TOP/install/hqc/20210204/BITC_CUST_ORDER_AUTHORITY.ldt PROFILE PROFILE_NAME="BITC_CUST_ORDER_AUTHORITY" APPLICATION_SHORT_NAME="BITC"
#upload
FNDLOAD apps/appsapps 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct $BITC_TOP/install/hqc/20210204/BITC_CUST_ORDER_AUTHORITY.ldt - CUSTOM_MODE=FORCE

--【Form个性化】
#download
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct $CUX_TOP/import/CUXTEST_CUS.ldt FND_FORM_CUSTOM_RULES function_name="CUXTEST"
#upload
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct $CUX_TOP/import/CUXTEST_CUS.ldt

--【描述性弹性域】
#download
FNDLOAD apps/xshx87246788 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt DESC_FLEX APPLICATION_SHORT_NAME="PO" DESCRIPTIVE_FLEXFIELD_NAME="PO_REQUISITION_HEADERS"
#upload
FNDLOAD apps/xshx87246788 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct XX_PO_REQ_HEADERS_DFF.ldt

--【职责】
#download
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"
#upload
FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct $CUX_TOP/import/CUXTEST_RESP.ldt

--【用户】
#download
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct XX_FND_USER_PASSI.ldt FND_USER USER_NAME='XZB'
#upload
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct XX_FND_USER_PASSI.ldt FND_USER

--【消息】
#download
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"
#upload
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct $CUX_TOP/import/CUXTEST_MSG.ldt

--【预警】
#download
FNDLOAD apps/apps 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt ALR_ALERTS APPLICATION_SHORT_NAME=XXCUST ALERT_NAME="XX - Alert Name"
#upload
FNDLOAD apps/apps 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct XX_CUSTOM_ALR.ldt CUSTOM_MODE=FORCE

--【工作流】
#WFLOAD <apps_user_name>/<password>@db 0 Y DOWNLOAD file_name.wft <Item_Type>
#download
WFLOAD apps/appsapps 0 Y DOWNLOAD BITC_CUSTOMER_ORDER.wft BITCCORD
#upload
WFLOAD apps/appsapps 0 Y UPLOAD $BITC_TOP/install/hqc/BITC_CUSTOMER_ORDER.wft

模块	文件名	描述
FND	afcpprog.lct	请求(含可执行、并发程序、值集、弹性域 )
FND	afcpexec.lct	可执行程序
FND	afattach.lct	附件
FND	afcpreqg.lct	请求组
FND	afcprset.lct	请求集
FND	afffload.lct	值集、关键性弹性域和描述性弹性域及相关安全性设置
FND	aflvmlu.lct	Lookups
FND	afmdmsg.lct	消息
FND	afscprof.lct	配置文件
FND	afscursp.lct	Application users,User Responsibilities,Security groups,Applications,Application Responsibilities and Exclusion Functions
FND	afsload.lct	FORM, FUNCTION, MENU, ENTRY, OBJECT, OBJECT_INSTANCE_SET, GRANT
FND	affrmcus.lct	Form个性化