本文檔由ice.xie原創,轉載請說明出處
FNDLOAD可以用來在不同的平台,環境間移植數據,比如可以相互間移植用戶,職責,功能,菜單等。。。
The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application
entity data between database and text file
Usage: FNDLOAD logon 0 Y mode configfile datafile [ entity [ param ... ] ]
where
logon is username/password[@connect]
mode is either UPLOAD or DOWNLOAD
configfile is the configuration file
datafile is the data file
entity is an entity name, or - to specify all values in an upload
param is a NAME=VALUE string used for parameter substitution
1.afsload.lct可用來移植包含
FORM, FUNCTION, MENU, ENTRY, OBJECT, OBJECT_INSTANCE_SET, GRANT
#下載表單NTK_POXRQVRQ的註冊資料
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form_name.ldt FORM FORM_NAME="NTK_POXRQVRQ"
#上傳表單NTK_POXRQVRQ的註冊資料
FNDLOAD apps/apps O Y UPLOAD $FND_TOP/patch/115/import/afsload.lct form_name.ldt FORM FORM_NAME="NTK_POXRQVRQ"
#下載所有應用為CUX下的表單資料
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct form_name.ldt FORM APPLICATION_SHORT_NAME="CUX"
#下載功能NTK_POXRQVRQ的註冊資料,可以包含相關的form的註冊信息
FNDLOAD apps/caocaoapps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct function_name.ldt FUNCTION FUNCTION_NAME="NTK_POXRQVRQ"
#下載菜單NTK_POXRQVRQ的註冊資料,可以包含相關的function,form的資料
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"
2.afscursp.lct可用來移植包含
# FND_USER - Application users
# FND_USER_RESP_GROUPS - User Responsibilities
# FND_SECURITY_GROUPS - Security groups
# FND_APPLICATION - Applications
# FND_RESPONSIBILITY - Application Responsibilities
# FND_RESP_FUNCTIONS - Exclusions
#下載用戶SYSADMIN的註冊資料,包含其擁有職責的定義
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER USER_NAME="SYSADMIN"
#下載職責11.ZZDZ.GYS的註冊資料
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="11.ZZDZ.GYS"
#下載應用AD的註冊資料
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct application.ldt FND_APPLICATION APPLICATION_SHORT_NAME="AD"
[@more@]