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可用于同步下列数据：

• 并发请求，可执行程序。
• 请求组，请求集。
• 配置文件选项。
• 键弹性域和描述性弹性域。
• 菜单。
• Form个性化。
• 附件。
• 消息。
• 值集和值。
• Lookup。
• 职责。
• 用户。
• 打印机定义。
• WebADI。
• ……

两个例子：
并发请求：
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/ 0 Y DOWNLOAD @FND:patch/115/import/afsload.lct .ldt FUNCTION FUNC_APP_SHORT_NAME= FUNCTION_NAME=

/*Upload Form. & Function*/
$FND_TOP/bin/FNDLOAD apps/ 0 Y UPLOAD @FND:patch/115/import/afsload.lct .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/ 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct .ldt REQ_SET REQUEST_SET_NAME=""

2 Request set stage link
FNDLOAD apps/ 0 Y DOWNLOAD @FND:patch/115/import/afcprset.lct .ldt REQ_SET_LINKS REQUEST_SET_NAME=""

/*Upload Request Set*/
1 Request set definitions
FNDLOAD apps/ 0 Y UPLOAD @FND:patch/115/import/afcprset.lct .ldt
2 Request set stage link
FNDLOAD apps/ 0 Y UPLOAD @FND:patch/115/import/afcprset.lct .ldt

##################################
/*Download Message*/
/*need download US ans ZHS, same as download MENU*/
FNDLOAD apps/ 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/ 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]
For Key Flexfields:
fdfcmp oraid/pswd 0 Y K[ey]
For Reports:
fdfcmp oraid/pswd 0 Y R[eport]
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 FND_LOOKUP_TYPE LOOKUP_TYPE=

/* Upload Lookups */
FNDLOAD apps/apps 0 Y UPLOAD @FND:/patch/115/import/aflvmlu.lct

##################################################################################
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