个性化EBS标准OAF页面(EO,+SQL全版本)

1、CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面目录TOC o 1-5 h z HYPERLINK l bookmark0个性化EBS标准OAF页面1 HYPERLINK l bookmark2目录1 HYPERLINK l bookmark4替换VO添加客户化属性（VO基于EO的版本）3 HYPERLINK l bookmark6实例背景3本例的页面：3EBS查看路径为：3原始VO位置3新VO位置3JDEVELOPER设置3 HYPERLINK l bookmark8环境变量：JDEV_USER_HOME3关键的JDEVELOPER设置3替换VO创

2、建客户化的属性（基于EO的VO）4客户化准备4创建新的VO（CuxConcurrentProgramVO）5设置VO参数6 HYPERLINK l bookmark20修改CuxConcurrentProgramVO7给CuxConcurrentProgramVO添加属性（关键）8 HYPERLINK l bookmark28替换ConcurrentProgramVO为CUXConcurrentProgramVO9 HYPERLINK l bookmark30为创建的属性添加一个ITEM11进入个性化页面11点击createITEM11设置ITEM属性11点击APPLY即可13 HYPERLI

3、NK l bookmark32结果测试14替换效果15注意事项15 HYPERLINK l bookmark38将个性化导入到EBS15 HYPERLINK l bookmark40设置jpximport.bat所在的位置15上传文件16查看部署效果17 HYPERLINK l bookmark54替换VO添加客户化属性（VO基于SQL的版本）（概要）18 HYPERLINK l bookmark56继承VO18添加字段18自动添加属性18为属性添加ITEM19测试运行19部署19运行效果19CreatedbyFrank.liuSeptember3,2009替换VO添加客户化属性（VO基于EO

4、的版本）实例背景本例的页面：/oracle/apps/fnd/cp/program/webui/SearchConcProgPGEBS查看路径为：systemadministration-concurrent-program原始VO位置gram.server.ConcurrentProgramVO新VO位置gram.server.CuxConcurrentProgramVOJDEVELOPER设置环境变量：JDEVUSERHOMED:EFDISKFtoolsOAFp6509325_R12_GENERICjdevhomejdev关键的JDEVELOPER设置在JavaOption处添加Djec七

5、=项目名称（无引号），如果不添加该设置，运行的时候将不能识别替换的VO客户化准备创建客户化函数CREATEORREPLACEFUNCTIONcux_oaf_test_f(ARG1VARCHAR2)RETURNVARCHAR2ISBEGINRETURNOAFTEST|TO_CHAR(ARG1)；EXCEPTIONWHENOTHERSTHENNULL;ENDcux_oaf_test_f;创建客户化的packagegram.serverCreatedbyFrank.liuSeptember3,2009CreatedbyFrank.liuSeptember3,2009创建新的1.创建VOCreated

6、byFrank.liuSeptember3,2009设置VO参数命名新VOEXTENDS选项，选择要被替换的VO（一定要继承原始的VO）点击下一步一直到完成修改修改SQL,在SELECT的最后添加，“,CUX_OAF_TEST_F(ConcurrentProgramEO.USER_CONCURRENT_PROGRAM_NAME)ASFRANKADD”函数CUX_OAF_TEST_F在准备阶段已经定义，其需要一个varchar2类型的参数。如下:selectrequest_id,program,requested_start_date,UserPhase,SswaStatus,phase_cod

7、e,requested_by,responsibility_application_id,responsibility_id,OFileStatus,program_application_id,program_short_name,request_date,decode(phase_code,C,decode(OFileStatus,NULL,NULL,decode(program_short_name,FNDREPRINT,NULL,phase_code),phase_code)asrepublish,CUX_OAF_TEST_F(program)ASFRANKADDfrom(select

8、requestid,program,requestedstartdate,个性化EBS标准OAF页面（EO,SQL全版本）fnd_conc_sswa.get_phase(phase_code,status_code,hold_flag,enabled,requested_start_date,request_id)asUserPhase,decode(fnd_conc_sswa.get_sswa_status(phase_code,status_code,hold_flag,enabled,requested_start_date,request_id),C,Fndcpnormalicon,G

9、,Fndcpwarningicon,E,Fndcperroricon,H,Fndcponholdicon,NULL)asSswaStatus,phase_code,requested_by,responsibility_application_id,responsibility_id,decode(fnd_conc_sswa.get_ofile_status(request_id),Y,Fndcpreqoutput,NULL)asOFileStatus,program_application_id,program_short_name,request_datefromfnd_conc_req_

10、summary_v)给CuxConcurrentProgramVO添加属性(关键)进入Atrribute选项TievObjectEditor:CUSConcurrentPrograV0个性化EBS标准OAF页面（EO,SQL全版本）个性化EBS标准OAF页面（EO,SQL全版本）EntityObjectsR.：w：dResijijrceC：ir.5UTerGrRcillljaclSfnisr.tOptimizerllcilsSecm-icupldApplicatiHrllCijncurrentfr:granlCijncurrentfr:granNExecutatlAppliz；=tExecut

11、atlIdExecuticrilleth匚dCcdAi-TUTieiLthl5th：idC：iceQuendijr.七丁匚1了1臼弐QueneMeth：iiiC：ideRequesiJetFligEnalileilflagAllijiiIliea：ileiV：ilreIJseZriSrEFrintFlEgRutlaImeFL述SrsFlagClassApfllcatiorJdCijncurrentLliesIcExecuticnljfti匚tlwSave&nfiitFligRequireiiStylsOutputPritStylsFritltErF日heflimmunVii1thAttiibu

12、tesSeisettheattributesyoiiwaiLtttircLudsinthimvie?ciLject.UsetheNevb-iitoiLtoaddgnewzievati.riliute.Xvai1ale：EeLectnd：进C-CiCijiLCiitrHiLtFrugrstJTi恩ZiiricniTetitJrugr:e:巨ranEjjLcllliackSegjTieiLt(Cijncurr已n:Fr:巨ranElJ:ROLLfOftinizerJodeloiLiziirreiLtPr：=iti1C:OfTIFiIZSecji-ityGroupld(Cijncurren:Fr:g

13、ranEj12-:ealileApplic；itioril1(Conciirmet?ruaneziitalileld(ConcijrrerL：Fm吾-hitEO:ElfC.flAEE:emtiimilethodZode(.CijiLizurrezLtFr匸g；-：=jTiZC:EXrg-jjientMelh口iiCode(CijncurrerLlJr:granEO:QHEUEieq-iestERtFlagCoriCTiiTeritFiPgrHiFD：EEQIE2ir.azileiiFlag：Conciui-eritFrogi-：dfiEiJ:EN.MLlF.Ml:?DisabledV：dlue

14、s(Trweient；lJseliiSfElrr：drLEieTLt.)?rintFL:ig(CurLCutTerFrogramEO:FjJHT_FU|.G：工口iAluneFL:ig(CuncurrerL：FmpranEO:FJI_ALOt；Sr5?1:igXoiLCuireiLtProgrsmED:SJSJLV?:extClaszApplicatiorLd(_ConcijiTentlr:1iCormhittrit?rop-anE0:L01：Zi:e2ntionZiptionsI.CoTLizurreTL+Pr:?：=jtiZC:Z1；EZS.fyilhitTint71s歹厂iiTir-n-

15、b-rpti十Ttti=*tsriPPlFATT宀叩亠;査口HIffi个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009FrankaddFrankadd选中选中FRANKADDFRANKADDFRANKADD二个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptemb

16、er3,2009说明：如果在Expression处填空，那在点击确定之后，该属性MappedtoColumnorSql选项将被取消，我们的个性化列将会不显示任何内容.所以Expressionc处必须有值替换ConcurrentProgramVO为CUXConcurrentProgramVO项目-ProjectProperties-BussinessComponents-Substitutions左边选择系统原来的VO(ConcurrentProgramVO),右边选择客户化的VO(CUXConcurrentProgramVO)点击ADD个性化EBS标准OAF页面（EO,SQL全版本）Creat

17、edbyFrank.liuSeptember3,2009为创建的属性添加一个进入个性化页面个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009GErrortggrgiscurrentlyenabledYourapplicazixillnotperformasmeIIv/hihLo-IsveIlocgincisorTheorganzationID1991isUTSocgnizEd.Yxrcu-rentCrgsnizaton

18、帕Ijeisrotrecojizedb/thepersonalizatontilYourpagecannotbeoerscnalizeda:thislevelvalu=.voumaychoosean3th=r阳ueandconzixe.Ch口osePersonaization匚ontExtChoosethepe-soislzationcontE：:teljv/by=el=ctngapersonaizattnvalu=力reachle=l.ScooeFage:Con:j-eitProgram”Ferion;li：it匚5hShrsdRegonswllbeappledtoallpagwswhere

19、the怕2匚exiiL.dTablsResblteTaoleYes低夕电MessageEtyledTe:t:Prog-anYesMessageEtyledTe:t:App1匚atiorYes设置ITEM属性需要设置的参数我的设置LevelSiteItemStyleMessageStyledTextIDcuxFrankAccessKeycuxFrankAdditionalTextcuxFrankHeightMaximumLength234PromptFrankaddViewAttributeFrankaddViewInstanceConcurrentProgramVOWidth45参考如图：已日

20、馆ItEin*IndicatesrequiredfieIdLevelSitevItemStyleMessageStyledTextvPropertyValue*IDCLixFrmnk（必填）AccessKeycuxFrmnk（必填）AdditionalTextCLixFrmnk（必填）AdminPersonalizationtruevAttributeSetCSSClassCommentsDataTypeVARCHAR2vDestinationFuncti广iDestinationURIDisableServerSideValidationfalsevExportView竝tributeExt

21、endsHeight要显示属性的高度，（:可以不填写）InitialSortSequencencneVLongTipRegionMasimumLength凶4NoWrapfalse7PrcimptFrankadd（填）|RenderedtruevRequiredno卜ScopeSearchAllowedfalsevSelectiveSearchCriteriafalsevSortAllowednovSortByViewAttributeTipMessageName%TipTypenonevTotalValuefalsevUserPersonalizationfalsevVerticalAlig

22、meritmiddle7ViewAttribute继承的g中添加的属性（必填）ViewInstance原来的*0的名字（必填）WarnAboutChangestruev谢泊岀要显示属性的宽度（必填）点击APPLY即可个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009结果测试SDjCorLTLectioreN至vigator詠8b国雜血口区因yalueSetLOYVCi-jJwebuicu51oniieatioris或一

23、或一或+CreateArLTiijtatiurJG.KmlCreat已虹umtatiurJGCO.clas5CreateCoricrGlJ.classCreateConcTr:glG.xmlCreateHairJiTCO.classCreateI：ELr：dniCCi.classCreatel:elt:iniFG.3mlDeTy-p已匸Ijttl:iinicLOVCO.classExecri：diTiaDjTJICO.c1:is5Exe匚:ntableJiTCO.classInconipatibi1ityRKCO.c1:assOnsitelntuJiTCO.classOnsitelrinter

24、UjVC0.claseF：i-:jinetei-JLffCCi.classFrijgr:iiTiCon51：itlclaseRequeetOptiorLFJTClJ.clas三RequeetF:ritlLStyleDjVC0.classRiiiLtimeStati三ti匚:三JJTCO.class5e：n：-izhCtlcTGCD.classSe:ELfChCuIIdr&匡1匚Eescnifces由匚壯匕ContentDeleteDeleteMakeCtrl+Shift-F9Rebuild)Alt+Shift-F9FR1ULDelmgE：lCijnip:=lteWithReplace世ith卜

25、-PL个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009替换效果个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009下一平上查我结果:第0-爲共0亍*NctethatthesearchiscaseinseTsitkeAdvancedSearchShortNameApplicazm|Do|匸laarConorrentPrcgdinX吊X查我个性化EBS标准OA

26、F页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009Program乂ApplkatinnfrankaddShortNameDEScriptionUpdateF.unConficiLratDrInoortEystenn配minstra:mOAFTESTF.unConhcuratarIrixrtSPAIMPInoortAppsDataintoSellingPointSetucnfiauraur2evelxerSettinqszystem忧min

27、stra:mOAFTESTSet；cnfigu-aurDevetperSstzingsSPRzINSetCon-rafo-DeveloperSettingsSetucnfiquraxirImportiZtntolEystenn忧minstra:mOAFTESTSetZcnfigu-axirImportCxtroSPRESIMPSetCon_rato-Impor:ControlSho1Zonfiau-atorDevetoerSettinqsEystennicminstra:mOAFTESTShoAZonfigu-aborDevetperSitingsSPRENGSEh加Conngurato-De

28、veloperSettingsSho1Zonfiau-atorIwortCoriTclEystenn忧minstrazionOAFTESTShoAZonfigu-aborImportCxtroSPREGIMPShjConngurato-InoortControl0CreateProgram=注意事项SavE5earch1.添加的字段需要加在最后一列之后，否则会报Index错误自定交屛舐複式缩舷血2.每做一次VO或者EO等businesscomponents的客户化都可能会需要产生新的java文件,那么这个时候需要将该目录复制到*/myclass/*目录下的相应位置，否则会报告找不到class的

29、错误.将个性化导入到设置jpximport.bat所在的位置该位置为jdeveloper安装位置的的*jdevbinoaextbin目录下可以使用setPATH=D:EFDISKEoafp6509325_R12_GENERICjdevbinoaextbin;%PATH%来设置，但是该设置是临时的，如果避免下一次再次设置，应该将D:EFDISKEoafp6509325_R12_GENERICjdevbinoaextbin;添加到环境变量。上传文件将*/myprojects/hand文件夹上传到服务器$JAVA_TOP/下将*/myclasses/hand文件夹上传到服务器$JAVA_TOP/下前

30、者是为了方便维护者查看源代码使用，后者是被用来执行的java可执行字节码.class文件。3.在dos执行导入命令jpximportD:EFDISKFtoolsOAFp6509325_R12_GENERICjdevhomejdevmypro.ectsOAFPAGE.jpx-usernameapps-passwordapps-dbconnection(description=(address_list=(address=(community=tcp.world)(protocol=tcp)(host=)(port=1521)(connect_data=(sid=PROD)查看导入结果如果出现如图的Importcompletedsuccessfully，那么就成功了,去页面看看结果吧。查看部署效果个性化EBS标准OAF页面（EO,SQL全版本）CreatedbyFrank.liuSeptember3,2009替换VO添加客户化属性（VO基于SQL的版本）（概要）为了避免啰嗦直接从不一样地方开始讲，而且基于SQL的VO比基于EO的VO添加属性还要简单些.继承VO添加字段selectrequest_id,program,requested_start_date,UserPhase,SswaStatus,phase_cod