FNDLOAD使用手册.docx
《FNDLOAD使用手册.docx》由会员分享,可在线阅读,更多相关《FNDLOAD使用手册.docx(12页珍藏版)》请在冰豆网上搜索。
FNDLOAD使用手册
FNDLOAD的用法
FNDLOAD是Oracle提供的一个数据同步工具,并且得到官方的支持。
FNDLOAD通过下载相关定义到一个文本文件做中转,再上在到另一个实例中。
通过该文件,可以方便地进行版本控制,同时也方便进行安装、移植和克隆。
ITPUB个人空间^ot5G
r
语法:
2]qRy3P3^o0FNDLOADlogon0Ymodeconfigfiledatafile[entity[param...]]
4F\V(D#&O7n!
g5X+W0logon:
EBS用户名/密码[@TNS连接别名]ITPUB个人空间gX}sEP
mode:
UPLOAD或DOWNLOADITPUB个人空间#f2OQ&T47w~/\4A6v
configfile:
配置文件路径,根据同步对象的不同需要选择不同的配置文件。
ITPUB个人空间@i6E
~
datafile:
数据文件
g"iU*[,Vn^�^+f0entity:
条目名称,或者上载时的所有相关值ITPUB个人空间q{.DZy)vJ
param:
参数格式为NAME=VALUEITPUB个人空间.R1b:
}H�BK
FNDLOAD可用于同步下列数据:
ITPUB个人空间RP9kje)]s:
U
1.并发请求,可执行程序。
2.请求组,请求集。
3.配置文件选项。
4.键弹性域和描述性弹性域。
5.菜单。
6.Form个性化。
7.附件。
8.消息。
9.值集和值。
10.Lookup。
11.职责。
12.用户。
13.打印机定义。
14.WebADI。
15.……
两个例子:
ITPUB个人空间0q_9n:
d^
并发请求:
ITPUB个人空间;}V-T-`t/t&Z
FNDLOADapps/apps_pwdOYDOWNLOAD$FND_TOP/patch/115/import/PROGRAMAPPLICATION_SHORT_NAME="HOM"CONCURRENT_PROGRAM_NAME="HOMWIPRD"ITPUB个人空间I|\$t4uTz9InP3@
FNDLOADapps/apps_pwdOYUPLOAD$FND_TOP/patch/115/import/
jy1e3q3l*N0Form个性化:
D#^CU#Zx�U5q0FNDLOADapps/apps_pwd0YDOWNLOAD$FND_TOP/patch/115/import/FND_FORM_CUSTOM_RULESfunction_name="AP_APXVDMVD"ITPUB个人空间"JD%^:
W2,m^B{
FNDLOADapps/apps_pwd0YUPLOAD$FND_TOP/patch/115/import/个人空间d"Ctk3\:
U&I
N4K
更多例子可参考$FND_TOP/patch/115/import目录下相关lct文件中的说明。
ITPUB个人空间If'wh5zi2`)i
默认条件下,FNDLOAD不会覆盖已有数据,但是它提供了一个参数用于强制覆盖:
\-a%B5Z8y+x]i1R8N"yI{~0CUSTOM_MODE=FORCEITPUB个人空间raQ9B
gG:
~
例:
)W4D5e-m
S&h-W0FNDLOADapps/apps_pwd0YUPLOAD$FND_TOP/patch/115/import/$XX_TOP/import/-CUSTOM_MODE=FORCE
h\2u
eoKjmu^0(似乎只针对菜单有效).
Howtodownloaddifferentseeddatatypes?
Y9h)AF*X,TV7}0AN:
ITPUB个人空间+MSf�QGIR5RP}5r
1-PrinterStyles
FKD"uO2r0FNDLOADOYDOWNLOAD$FND_TOP/patch/115/import/STYLE.PRINTER_STYLE_NAME="printerstyle.name"ITPUB个人空间hAGLrWR
ITPUB个人空间EW3VMf5J5Q
2-Lookups
/Q&EIr+Dy`-|0FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/FND_LOOKUP_TYPEAPPLICATION_SHORT_NAME="prod"ITPUB个人空间C+uU+X]/P
LOOKUP_TYPE="lookupname"ITPUB个人空间H[L
[#e2U1i~5O
WV6K}$}kQ]03-DescriptiveFlexfieldwithallofspecificContexts
q1[4T0FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/DESC_FLEXP_LEVEL="COL_ALL:
REF_ALL:
CTX_ONE:
SEG_ALL"APPLICATION_SHORT_NAME="prod"DESCRIPTIVE_FLEXFIELD_NAME="descflexname"P_CONTEXT_CODE="contextname"ITPUB个人空间
t^5r8{v
Q8u*US8Nk04-KeyFlexfieldStructuresITPUB个人空间#VYs%d9p
FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/KEY_FLEXP_LEVEL="COL_ALL:
FQL_ALL:
SQL_ALL:
STR_ONE:
WFP_ALL:
SHA_ALL:
CVR_ALL:
SEG_ALL"APPLICATION_SHORT_NAME="prod"ID_FLEX_CODE="keyflexcode"P_STRUCTURE_CODE="structurename"
&B5`haT0
2\/D
_$S7NR05-ConcurrentProgramsITPUB个人空间ako�XH
RUIc}Y
FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/PROGRAMAPPLICATION_SHORT_NAME="prod"CONCURRENT_PROGRAM_NAME="concurrentname"ITPUB个人空间3AE0l/OSQb
ITPUB个人空间#Od_)\s(C8WGm
6-ValueSets
O!
`$[.a!
AlR0FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/VALUE_SETFLEX_VALUE_SET_NAME="valuesetname"
i|yUv0
$f{']6Yb&h8Pv07-ValueSetswithvalues
#c
[kv+B3K;Q1O5G9Os:
p0FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/VALUE_SET_VALUEFLEX_VALUE_SET_NAME="valuesetname"
fv!
hP/T$[5i0ITPUB个人空间d
q%~B(kROt
8-ProfileOptions
/S#`0f3f0j4t9H0FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/PROFILEPROFILE_NAME="profileoption"APPLICATION_SHORT_NAME="prod"ITPUB个人空间&FR8Q!
l6KG
ITPUB个人空间!
~M+E6Imp-{
`
g'V
8-RequestGroupsITPUB个人空间6e7Q,as%|o_n
Oj
FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/REQUEST_GROUPREQUEST_GROUP_NAME="requestgroup"APPLICATION_SHORT_NAME="prod"
JV4H@^0B({z*qH6h0
Pn'`6S%Gz!
|YS010-RequestSetsITPUB个人空间!
duxH,vt
eM
FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/REQ_SETITPUB个人空间{5v|a|[,H!
T
APPLICATION_SHORT_NAME="prod"REQUEST_SET_NAME="requestset"ITPUB个人空间N;x(a$X#UiO1U*A-F
6gkk-Responsibilities
+v#L'`*!
C:
w9\w}0FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/FND_RESPONSIBILITYRESP_KEY="responsibility"
uii;_\
`0ITPUB个人空间z)GR`kHZ*w)u_;^
12-MenusITPUB个人空间X$l1i&f
FNDLOAD OYDOWNLOAD$FND_TOP/patch/115/import/MENUMENU_NAME="menu_name"
Y+etm9B)_0
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
开发完成,在测试环境注册.然后下载,然后上传.
#################################
M4m5`-Mn0/*DownloadForm.&Function*/
bF%Jw;^0NLS_LANG="SIMPLIFIED";exportNLS_LANGITPUB个人空间(LU_$UeO
$FND_TOP/bin/FNDLOADapps/0YDOWNLOAD@FND:
patch/115/import/.ldtFUNCTIONFUNC_APP_SHORT_NAME=FUNCTION_NAME=
/*UploadForm.&Function*/ITPUB个人空间~/e0]O}ot4C
$FND_TOP/bin/FNDLOADapps/0YUPLOAD@FND:
patch/115/import/.ldt
#################################ITPUB个人空间+S(B;YN!
d
/*DownloadMenu*/
kD0mS(pW0/*needdownloadbothversionofUSandZHS*/ITPUB个人空间Fgfl4?
/*DownloadUSversion*/
2GHtn;ZucVeN0FNDLOADapps/scerp10YDOWNLOAD@FND:
patch/115/import/MENUMENU_NAME=menu
/*DownloadZHSversion*/ITPUB个人空间&U}@6m(^VmI^/dC
NLS_LANG="SIMPLIFIED";exportNLS_LANGITPUB个人空间/eF|5i!
zJn
FNDLOADapps/scerp10YDOWNLOAD@FND:
patch/115/import/MENUMENU_NAME=menu
/*DownloadSubMenu*/
aCZ�S"%dh0FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/MENUPARENT_MENU_NAME="PA_SUPERUSER_GUI(PC)"SUB_MENU_NAME=CMCC_PA_ASSET
/*UploadMenu*/
K[P-E;{*[%P0/*UploadUSversionfirst*/
9M2u+m_V)Fk:
JFO0FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/
/*thenuploadZHS*/ITPUB个人空间r2x1ay
S8|#K
FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/-UPLOAD_MODE=NLS
#################################
)@FcQJ0/*DownloadRequestSet*/
5w5_md{xi&@6y01RequestsetdefinitionsITPUB个人空间ptudadnr1[
FNDLOADapps/0YDOWNLOAD@FND:
patch/115/import/.ldtREQ_SETREQUEST_SET_NAME=""
2RequestsetstagelinkITPUB个人空间D'I6ZA
Rqo
FNDLOADapps/0YDOWNLOAD@FND:
patch/115/import/.ldtREQ_SET_LINKSREQUEST_SET_NAME=""
/*UploadRequestSet*/ITPUB个人空间S/@k/DJ&p"@%K
1RequestsetdefinitionsITPUB个人空间M'dM9A0p&P~~
FNDLOADapps/0YUPLOAD@FND:
patch/115/import/.ldtITPUB个人空间E/Jr7{!
PP"H
2Requestsetstagelink
NiKB|2_0FNDLOADapps/0YUPLOAD@FND:
patch/115/import/.ldt
##################################ITPUB个人空间-J
r
Pf:
Mqn,GJ4?
/*DownloadMessage*/ITPUB个人空间+i
~!
U'WM9Zb!
A
/*needdownloadUSansZHS,sameasdownloadMENU*/ITPUB个人空间P7z'i!
|dl:
i\t
FNDLOADapps/0YDOWNLOAD@FND:
patch/115/import/FND_NEW_MESSAGESMESSAGE_NAME=message_name
/*UploadMessage*/
&u
LD
_:
NQ0/*uploadbothofZHSandUS*/
A#X
[Y(D:
i,M�`0FNDLOADapps/0YUPLOAD@FND:
patch/115/import/
##################################ITPUB个人空间T%!
4r
nU5^
Q*yvF
/*DownloadProfile*/ITPUB个人空间.`sZ"yKe
sV
FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/PROFILEPROFILE_NAME=profile_name
/*UploadProfile*/
8WBB&FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/个人空间0v'|IJ{s
#Don'tknowhowtouseFND_PROFILE_OPTION_VALUES
###################################
I3L1ZhA`0/*Downloaddescriptionflexfield*/ITPUB个人空间�Ep}A`e8Jsa#\
FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/DESC_FLEXDESCRIPTIVE_FLEXFIELD_NAME=description_flexfield_name---(not)ITPUB个人空间!
lg2T
clicktitle->help->ITPUB个人空间4xU9^)e9]:
s
diagnostics->
[
Q5b,M"k0examine->
lq%wa*s2|0block=table,field=DESCRIPTIVE_FLEXFIELD_NAME->ITPUB个人空间;PH{!
o
X&I%v|G1{
description_flexfield_name=value
/*Uploaddescriptionflexfield*/ITPUB个人空间l|B,S#G)h,o
FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/
/*downloadonly1context*/ITPUB个人空间0rh9V)M;`)zZ
FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/DESC_FLEXDESCRIPTIVE_FLEXFIELD_NAME=PER_EVENTSP_CONTEXT_CODE='GlobalDataElements'P_LEVEL='COL_ALL:
REF_ALL:
CTX_ONE:
SEG_ALL'
###################################
5[y"u/}8S:
sf0/*Downloadvalueset*/
y0]lTE0FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/VALUE_SETFLEX_VALUE_SET_NAME=valueset_name
/*Uploaddescriptionflexfield*/ITPUB个人空间OL@_OX
FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/
###################################
m}^ys;V
f.}0/*Uploadworkflow*/
k8h!
M/R#\0WFLOADapps/apps0YUPLOAD
###################################ITPUB个人空间1O*Lad:
s{{
/*DownloadConcurrentPrograms*/ITPUB个人空间y_#FF"D4\I
FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/PROGRAMCONCURRENT_PROGRAM_NAME=concurrent_programsAPPLICATION_SHORT_NAME=application_short_name
/*UploadConcurrentPrograms*/
s5}lo-cz0FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/
/*overwritetheoldconcurrentprograms*/
qW1bpr)Xd%Ny}i#f0FNDLOADapps/apps0YUPLOAD@FND:
patch/115/import/-CUSTOM_MODE=FORCE
######################################################
\j2G*e
_7@X0/*compileflexfieldstructureusingunixcommand*/
H|5n_z!
CeG0Thesyntaxforfdfcmp:
ITPUB个人空间~$y5Q2b
n4Ut
ForDescriptiveFlexfields:
ITPUB个人空间@^TZ[6u�s9b#Q
fdfcmporaid/pswd0YD[escriptive]ITPUB个人空间N7j)Q!
Ma~7q%E|'yq+O
ForKeyFlexfields:
ITPUB个人空间k%E
gbp%I
fdfcmporaid/pswd0YK[ey]
8beh/aRi|)D0ForReports:
ITPUB个人空间2XY!
S5{m^.`8t`:
~P
fdfcmporaid/pswd0YR[eport]
h5~l0`si9GIlr#R0eg:
r[Hhd0fdfcmpapps/apps0YRCGLQCGLJNR1
###################################ITPUB个人空间4bAuKn(I9Dn7fU+e
/*DownloadConcurrentProgramPrinterStyle.*/
/`
{GL^]e0FNDLOADapps/apps0YDOWNLOAD@FND:
patch/115/import/STYLE.PRINTER_STYLE_NAME=CMCC_LANDSCAPE_220_66
######################################################ITPUB个人空间)aI-j:
]K\:
M
/*DownloadLookups*/
7Xd#M-r)c0FNDLOADapps/apps0YDOWNLOAD@FND:
/patch/115/import/FND_LOOKUP_TYPELOOKUP_TYPE=
/*UploadLookups*/ITPUB个人空间`WpXHxo,@(_O8P
FNDLOADapps