FNDLOAD使用手册
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
FNDLOAD的用法
FNDLOAD是Oracle提供的一个数据同步工具,并且得到官方的支持。
FNDLOAD通过下载相关定义到一个文本文件做中转,再上在到另一个实例中。
通过该文件,可以方便地进行版本控制,同时也方便进行安装、移植和克隆。
语法:
FNDLOAD logon 0 Y mode configfile datafile [ entity [ param ... ] ]
logon:EBS用户名/密码[@TNS连接别名]
mode: UPLOAD 或 DOWNLOAD
configfile: 配置文件路径,根据同步对象的不同需要选择不同的配置文件。
datafile: 数据文件
entity: 条目名称, 或者上载时的所有相关值
param: 参数格式为 NAME=VALUE
FNDLOAD可用于同步下列数据:
1.并发请求,可执行程序。
2.请求组,请求集。
3.配置文件选项。
4.键弹性域和描述性弹性域。
5.菜单。
6.Form个性化。
7.附件。
8.消息。
9.值集和值。
10.Lookup。
11.职责。
12.用户。
13.打印机定义。
14.WebADI。
15.……
两个例子:
并发请求:
FNDLOAD apps/apps_pwd O Y DOWNLOAD
$FND_TOP/patch/115/import/afcpprog.lct HOMWIPRD.ldt PROGRAM APPLICATION_SHORT_NAME="HOM" CONCURRENT_PROGRAM_NAME="HOMWIPRD" FNDLOAD apps/apps_pwd O Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct HOMWIPRD.ldt
Form个性化:
FNDLOAD apps/apps_pwd 0 Y DOWNLOAD
$FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt
FND_FORM_CUSTOM_RULES function_name="AP_APXVDMVD"
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct XX_AP_APXVDMVD.ldt
更多例子可参考 $FND_TOP/patch/115/import 目录下相关lct文件中的说明。
默认条件下,FNDLOAD不会覆盖已有数据,但是它提供了一个参数用于强制覆盖:CUSTOM_MODE=FORCE
例:
FNDLOAD apps/apps_pwd 0 Y UPLOAD $FND_TOP/patch/115/import/afscprof.lct $XX_TOP/import/CUSTOM_PROF.ldt - CUSTOM_MODE=FORCE
(似乎只针对菜单有效).
How to download different seed data types?
AN:
1 - Printer Styles
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE. PRINTER_STYLE_NAME="printer style. name"
2 - Lookups
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME="prod"
LOOKUP_TYPE="lookup name"
3 - Descriptive Flexfield with all of specific Contexts
FNDLOAD usernm/pwd@dbname 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="prod" DESCRIPTIVE_FLEXFIELD_NAME="desc flex name" P_CONTEXT_CODE="context name"
4 - Key Flexfield Structures
FNDLOAD usernm/pwd@dbname 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="prod" ID_FLEX_CODE="key flex code" P_STRUCTURE_CODE="structure name"
5 - Concurrent Programs
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME="prod" CONCURRENT_PROGRAM_NAME="concurrent name"
6 - Value Sets
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET FLEX_VALUE_SET_NAME="value set name"
7 - Value Sets with values
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME="value set name"
8 - Profile Options
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afscprof.lct file_name.ldt PROFILE PROFILE_NAME="profile option" APPLICATION_SHORT_NAME="prod"
8 - Request Groups
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afcpreqg.lct file_name.ldt REQUEST_GROUP REQUEST_GROUP_NAME="request group" APPLICATION_SHORT_NAME="prod"
10 - Request Sets
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afcprset.lct file_name.ldt REQ_SET APPLICATION_SHORT_NAME="prod" REQUEST_SET_NAME="request set"
11 - Responsibilities
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct file_name.ldt FND_RESPONSIBILITY RESP_KEY="responsibility"
12 - Menus
FNDLOAD usernm/pwd@dbname O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct file_name.ldt MENU MENU_NAME="menu_name"
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
开发完成,在测试环境注册.然后下载,然后上传.
#################################
/*Download Form. & Function*/
NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK";export NLS_LANG
$FND_TOP/bin/FNDLOAD apps/<password> 0 Y DOWNLOAD
@FND:patch/115/import/afsload.lct <your name>.ldt FUNCTION
FUNC_APP_SHORT_NAME=<your name> FUNCTION_NAME=<your name>
/*Upload Form. & Function*/
$FND_TOP/bin/FNDLOAD apps/<password> 0 Y UPLOAD
@FND:patch/115/import/afsload.lct <your name>.ldt
#################################
/*Download Menu*/
/*need download both version of US and ZHS*/
/*Download US version*/
FNDLOAD apps/scerp1 0 Y DOWNLOAD @FND:patch/115/import/afsload.lct menu.ldt MENU MENU_NAME=menu
/*Download ZHS version*/
NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK";export NLS_LANG FNDLOAD apps/scerp1 0 Y DOWNLOAD @FND:patch/115/import/afsload.lct menu_zhs.ldt MENU MENU_NAME=menu
/*Download Sub Menu*/
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afsload.lct CMCC_PA_ASSET_US.ldt MENU PARENT_MENU_NAME="PA_SUPERUSER_GUI (PC)" SUB_MENU_NAME=CMCC_PA_ASSET
/*Upload Menu*/
/*Upload US version first*/
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct menu.ldt
/*then upload ZHS*/
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct
menu_zhs.ldt - UPLOAD_MODE=NLS
#################################
/*Download Request Set*/
1 Request set definitions
FNDLOAD apps/<apps_pwd> 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct <sample_definitions>.ldt REQ_SET REQUEST_SET_NAME="<Request_Set_Code>"
2 Request set stage link
FNDLOAD apps/<apps_pwd> 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct <sample_links>.ldt REQ_SET_LINKS REQUEST_SET_NAME="<Request_Set_Code>"
/*Upload Request Set*/
1 Request set definitions
FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afcprset.lct
<sample_definitions>.ldt
2 Request set stage link
FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afcprset.lct <sample_links>.ldt
##################################
/*Download Message*/
/*need download US ans ZHS, same as download MENU*/
FNDLOAD apps/<apps_pwd> 0 Y DOWNLOAD @FND:patch/115/import/afmdmsg.lct message.ldt FND_NEW_MESSAGES MESSAGE_NAME=message_name
/*Upload Message*/
/*upload both of ZHS and US*/
FNDLOAD apps/<apps_pwd> 0 Y UPLOAD @FND:patch/115/import/afmdmsg.lct message.ldt
##################################
/*Download Profile*/
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afscprof.lct profile.ldt PROFILE PROFILE_NAME=profile_name
/*Upload Profile*/
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afscprof.lct profile.ldt
#Don't know how to use FND_PROFILE_OPTION_VALUES
###################################
/*Download description flexfield*/
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct descript_flex.ldt DESC_FLEX
DESCRIPTIVE_FLEXFIELD_NAME=description_flexfield_name ---(not title) click title->help->
diagnostics->
examine->
block=table,field=DESCRIPTIVE_FLEXFIELD_NAME->
description_flexfield_name=value
/*Upload description flexfield*/
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afffload.lct descript_flex.ldt
/*download only 1 context */
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct descript_flex.ldt DESC_FLEX DESCRIPTIVE_FLEXFIELD_NAME=PER_EVENTS
P_CONTEXT_CODE='Global Data Elements'
P_LEVEL='COL_ALL:REF_ALL:CTX_ONE:SEG_ALL'
###################################
/*Download valueset*/
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afffload.lct valueset.ldt VALUE_SET FLEX_VALUE_SET_NAME=valueset_name
/*Upload description flexfield*/
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afffload.lct valueset.ldt
###################################
/*Upload workflow*/
WFLOAD apps/apps 0 Y UPLOAD workflow.wft
###################################
/* Download Concurrent Programs */
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afcpprog.lct concurrent_program.ldt PROGRAM
CONCURRENT_PROGRAM_NAME=concurrent_programs
APPLICATION_SHORT_NAME=application_short_name
/* Upload Concurrent Programs */
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct QGLXJLLB.ldt
/* overwrite the old concurrent programs */
FNDLOAD apps/apps 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct QGLPRJNL.ldt - CUSTOM_MODE=FORCE
######################################################
/* compile flexfield structure using unix command */
The syntax for fdfcmp:
For Descriptive Flexfields:
fdfcmp oraid/pswd 0 Y D[escriptive] <appl_short_name> <desc_flex_name> For Key Flexfields:
fdfcmp oraid/pswd 0 Y K[ey] <appl_short_name> <id_flex_code id_flex_num> For Reports:
fdfcmp oraid/pswd 0 Y R[eport] <appl_short_name> <report_name>
eg:
fdfcmp apps/apps 0 Y R CGL QCGLJNR1
###################################
/* Download Concurrent Program Printer Style. */
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:patch/115/import/afcppstl.lct CMCC_LANDSCAPE_220_66.ldt STYLE.
PRINTER_STYLE_NAME=CMCC_LANDSCAPE_220_66
######################################################
/* Download Lookups */
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:/patch/115/import/aflvmlu.lct <ldt filename> FND_LOOKUP_TYPE LOOKUP_TYPE=<LOOKUP TYPE NAME>
/* Upload Lookups */
FNDLOAD apps/apps 0 Y UPLOAD @FND:/patch/115/import/aflvmlu.lct <ldt filename>
##################################################################### #############
web plsql
FNDLOAD apps/apps 0 Y DOWNLOAD @FND:/patch/115/import/afscursp.lct QPACAPITAL_PLSQL.ldt FND_ENABLED_PLSQL PLSQL_NAME=QPACAPITAL
FNDLOAD apps/apps 0 Y UPLOAD @FND:/patch/115/import/afscursp.lct QPACAPITAL_PLSQL.ldt
##################################################################### ########
11.5.10新增的“帮助-诊断-自定义代码-个性化”功能中的函数可以通过下面的语句进行移植:
其中的“function_name”可以从“帮助-诊断-自定义代码-个性化-函数名”中获得。
下载:ASCII
FNDLOAD apps/apps 0 Y DOWNLOAD $FND_TOP/patch/115/import/affrmcus.lct POXPRREPR.lct FND_FORM_CUSTOM_RULES function_name=PO_POXRQERQ
上传:ASCII
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/affrmcus.lct POXPRREPR.lct。