Oracle EBS配置移植工具FNDLOAD使用

The Generic Loader (FNDLOAD) is a concurrent program that can transfer Oracle Application entity data between database and text file.The loader reads a configuration file to determine which entity to access.

1 - Printer Styles
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME="printer style name"

2 - Lookups
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="FND"
LOOKUP_TYPE="lookup name"

3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=’COL_ALL:REF_ALL:CTX_ONE:SEG_ALL’ APPLICATION_SHORT_NAME="FND" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"

Examples:
Note <274528.1> - Note How To Download Single Context Using FNDLOAD For Descriptive Flexfield.
Note <256573.1> - How To Download/Upload Descriptive Flexfield With Name $SRS$.

4 - Key Flexfield Structures
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=’COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL’ APPLICATION_SHORT_NAME="FND" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"

5 - Concurrent Programs
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="FND" CONCURRENT_PROGRAM_NAME="concurrent name"

6 - Value Sets
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"

7 - Value Sets with values
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"

8 - Profile Options
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="FND"

9 - Request Groups
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="FND"

 

To download the concurrent program belonging to which request group:

FNDLOAD apps/******(password) O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct DATALOADERFILE.ldt REQUEST_GROUP REQUEST_GROUP_NAME="Your Request Group name" APPLICATION_SHORT_NAME="Your Request Group Application short name" REQUEST_GROUP_UNIT UNIT_NAME="Your concurrent program short name"

---example: FNDLOAD apps/xxxx O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct xxxx_RG.ldt REQUEST_GROUP REQUEST_GROUP_NAME="XML Publisher Request Set" APPLICATION_SHORT_NAME="XDO" REQUEST_GROUP_UNIT UNIT_NAME="xxx"

10 - Request Sets
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET
APPLICATION_SHORT_NAME="FND" REQUEST_SET_NAME="request set"

Examples:
Note <247126.1> - How To Download Request Set Definition From One Instance And  Upload On Another Instance

11 - Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"

12 - Menus
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"


Oracle Application System Administrator's Guide Appendix C has detail description on the usage of loaders.

值集移植
Download:
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct CMCC_PY_SRS_PAYMETH.ldt VALUE_SET FLEX_VALUE_SET_NAME="CMCC_PY_SRS_PAYMETH"

Upload:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct CMCC_PY_SRS_PAYMETH.ldt

 

 

请求程序和可执行程序移植
Download:
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct CMCC_PAY_LINK_MAIN.ldt PROGRAM APPLICATION_SHORT_NAME="CPER" CONCURRENT_PROGRAM_NAME="CMCC_PAY_LINK_MAIN"

Upload:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct  CMCC_PAY_LINK_MAIN.ldt

 

 

LOG_FILE=migrate`date +%d%m%y`.log
if [ $# -ne 1 ]; then
 echo "parameter amount is not correct,You must input apps password"
 exit 1
fi

 

echo "Upload VALUE_SET" | tee -a ${LOG_FILE}

NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

export NLS_LANG

$FND_TOP/bin/FNDLOAD apps/$1 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct ./ldt/CUX_PO_ORDER_NUMBER.ldt 2>&1 | tee -a ${LOG_FILE}
$FND_TOP/bin/FNDLOAD apps/$1 0 Y UPLOAD $FND_TOP/patch/115/import/afffload.lct ./ldt/CUX_PO_RELEASES_NUMBER.ldt 2>&1 | tee -a ${LOG_FILE}

cp ./reports/CUXPOORDER.rdf $CUX_TOP/reports/ZHS/CUXPOORDER.rdf
cp ./reports/CUXPOORDER.rdf $CUX_TOP/reports/US/CUXPOORDER.rdf

echo "Upload concurrent program" | tee -a ${LOG_FILE}

$FND_TOP/bin/FNDLOAD apps/$1 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct  ./ldt/CUXPOORDER.ldt 2>&1 | tee -a ${LOG_FILE}

echo "The migrate is completed" | tee -a ${LOG_FILE}