如下為 11.5.10 版本以上可用的 FNDLOAD 語法,可將各種設定下載轉出為 .ldt 的檔案,然後搬移此檔案到新的環境,再透過上傳的指令就能完成設定。
在導入階段多個環境間 (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'
** 匯入 Concurrent Programs 時,會連同 Parameters 指定的 Value Set 的設定一併匯出,所以在正常情況下,只需要會出 Concurrent Programs 即可。
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_SETAPPLICATION_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'
在導入階段多個環境間 (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'
** 匯入 Concurrent Programs 時,會連同 Parameters 指定的 Value Set 的設定一併匯出,所以在正常情況下,只需要會出 Concurrent Programs 即可。
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_SETAPPLICATION_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'
User Responsibilities
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER USER_NAME=’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'
Attachment
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct file_name.ldt FND_ATTACHMENT_FUNCTIONS FUNCTION_NAME='XX'
FNDLOAD apps/apps O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_USER USER_NAME=’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'
Attachment
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/afattach.lct file_name.ldt FND_ATTACHMENT_FUNCTIONS FUNCTION_NAME='XX'
WebADI
Integrator
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct file_name.ldt BNE_INTEGRATORS INTEGRATOR_ASN='XX' INTEGRATOR_CODE='YY'
Contents
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct file_name.ldt BNE_CONTENTS CONTENT_ASN='XX' CONTENT_CODE='YY'
Layout
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct file_name.ldt BNE_LAYOUTS LAYOUT_ASN='XX' LAYOUT_CODE='YY'
Mappings
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnemap.lct file_name.ldt BNE_MAPPINGS MAPPING_ASN='XX' MAPPING_CODE='YY'
Parameter Lists
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneparamlist.lct file_name.ldt BNE_PARAM_LISTS PARAM_LIST_ASN='XX' PARAM_LIST_CODE='YY'
Components
FNDLOAD apps/apps 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecomp.lct file_name.ldt BNE_COMPONENTS COMPONENT_ASN='XX' COMPONENT_CODE='YY'
沒有留言:
張貼留言