Aloz 的 Oracle ERP 天地

如下為 11.5.10 版本以上可用的 FNDLOAD 語法, 可將各種設定 Download 轉出為 .ldt 的檔案搬移此檔案到新的環境再透過 Upload 的語法就能完成設定

在導入階段多個環境間 (Test/Pilot-Run/Prod) 進行設定時非常有幫助

Upload
FNDLOAD apps/dlseh 0 Y UPLOAD $FND_TOP/patch/115/import/XXXX.lct file_name.ldt (要看你 Upload 的 ldt 檔對應的 lct 來決定 XXXX 的值)

** 如果打錯 lct 一定會失敗, 在指令下會出現 Segmentation fault **

Functions/Forms
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt FUNCTION FUNCTION_NAME='XX' APPLICATION_SHORT_NAME='YY'

Menus
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME='XX'

Personalization
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES FUNCTION_NAME='XX' APPLICATION_SHORT_NAME='YY'

Printer Styles
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME='XX'

Lookups
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME='XX' LOOKUP_TYPE='YY'

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='XX' APPLICATION_SHORT_NAME='YY' DESCRIPTIVE_FLEXFIELD_NAME='ZZ' P_CONTEXT_CODE='OO'

Key Flexfield Structures
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL='XX' APPLICATION_SHORT_NAME='YY' ID_FLEX_CODE='ZZ' P_STRUCTURE_CODE='OO'

Concurrent Programs
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME='XX' CONCURRENT_PROGRAM_NAME='YY'

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='XX'

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='XX'

Profile Options
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME='XX' APPLICATION_SHORT_NAME='YY'

Request Groups
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME='XX' APPLICATION_SHORT_NAME='YY'

Request Sets
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME='XX' REQUEST_SET_NAME='YY'

Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY='XX'

Forms Personalization
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct file_name.ldt FND_FORM_CUSTOM_RULES function_name='XX'

Attachement
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct file_name.ldt FND_ATTACHMENT_FUNCTIONS FUNCTION_NAME='XX'