oracle ebs监控工具,Oracle EBS工具FNDLOAD快樂體驗(-)

本文檔由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@]