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

个性化EBS标准OAF页面(EO, SQL全版本)个性化EBS标准OAF页面目录个性化EBS标准OAF页面1目录1替换VO添加客户化属性(VO基于EO的版本)3实例背景3本例的页面：3EBS查看路径为：3原始VO位置3新VO位置3JDEVELOPER设置3环境变量：JDEV_USER_HOME3关键的JDEVELOPER设置3替换VO创建客户化的属性(基于EO的VO)4客户化准备4创建新的VO(CuxConcurrentProgramVO)5设置VO参数6修改CuxConcurrentProgramVO7给CuxConcurrentProgramVO添加属性（关键）8替换ConcurrentProgramVO为CUXConcurrentProgramVO9为创建的属性添加一个ITEM11进入个性化页面11点击create ITEM11设置ITEM属性11点击APPLY 即可13结果测试14替换效果15注意事项15将个性化导入到EBS15设置jpximport.bat所在的位置15上传文件16查看部署效果17替换VO添加客户化属性(VO基于SQL的版本)(概要)18继承VO18添加字段18自动添加属性18为属性添加ITEM19测试运行19部署19运行效果19替换VO添加客户化属性(VO基于EO的版本)实例背景本例的页面：/oracle/apps/fnd/cp/program/webui/SearchConcProgPGEBS查看路径为：system administration-concurrent-program原始VO位置gram.server.ConcurrentProgramVO新VO位置gram.server.CuxConcurrentProgramVOJDEVELOPER设置环境变量：JDEV_USER_HOMED:EF DISKFtoolsOAFp6509325_R12_GENERICjdevhomejdev关键的JDEVELOPER设置在Java Option 处添加 Dject=”项目名称(无引号)”，如果不添加该设置，运行的时候将不能识别替换的VO替换VO创建客户化的属性(基于EO的VO)客户化准备1. 创建客户化函数CREATE OR REPLACE FUNCTION cux_oaf_test_f(ARG1 VARCHAR2) RETURN VARCHAR2 ISBEGINRETURN OAF TEST | TO_CHAR(ARG1);EXCEPTIONWHEN OTHERS THEN NULL;END cux_oaf_test_f;2. 创建客户化的gram.server创建新的VO(CuxConcurrentProgramVO)1. 创建VO设置VO参数1. 命名新VO 2. EXTENDS 选项, 选择要被替换的VO(一定要继承原始的VO)点击下一步一直到完成修改CuxConcurrentProgramVOl 修改SQL， 在SELECT 的最后添加，“,CUX_OAF_TEST_F(ConcurrentProgramEO.USER_CONCURRENT_PROGRAM_NAME) AS FRANKADD”l 函数CUX_OAF_TEST_F 在准备阶段已经定义，其需要一个varchar2类型的参数。如下:selectrequest_id, program, requested_start_date, UserPhase, SswaStatus, phase_code, 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) as republish,CUX_OAF_TEST_F(program) AS FRANKADDfrom(select request_id, program, requested_start_date, fnd_conc_sswa.get_phase(phase_code, status_code, hold_flag, enabled, requested_start_date, request_id) as UserPhase,decode(fnd_conc_sswa.get_sswa_status(phase_code, status_code, hold_flag, enabled, requested_start_date, request_id),C,Fndcpnormalicon, G, Fndcpwarningicon, E, Fndcperroricon, H,Fndcponholdicon,NULL) as SswaStatus,phase_code, requested_by, responsibility_application_id, responsibility_id,decode(fnd_conc_sswa.get_ofile_status(request_id),Y, Fndcpreqoutput, NULL) as OFileStatus, program_application_id, program_short_name, request_date from fnd_conc_req_summary_v)给CuxConcurrentProgramVO添加属性（关键）1. 进入Atrribute选项2. 选择new创建attributeFRANKADDFRANKADDFrankadd选中说明：如果在Expression 处填空，那在点击确定之后，该属性Mapped to Column or Sql 选项将被取消，我们的个性化列将会不显示任何内容. 所以Expressionc处必须有值替换ConcurrentProgramVO为CUXConcurrentProgramVO1. 项目-Project Properties-Bussiness Components-Substitutions2. 左边选择系统原来的VO(ConcurrentProgramVO), 右边选择客户化的VO(CUXConcurrentProgramVO)3. 点击ADD为创建的属性添加一个ITEM进入个性化页面点击create ITEM设置ITEM属性需要设置的参数我的设置LevelSiteItem StyleMessage Styled TextIDcuxFrankAccess KeycuxFrankAdditional TextcuxFrankHeightMaximum Length234PromptFrankaddView AttributeFrankaddView InstanceConcurrentProgramVOWidth45参考如图：点击APPLY 即可结果测试替换效果注意事项1. 添加的字段需要加在最后一列之后，否则会报Index错误2. 每做一次VO或者EO等business components的客户化都可能会需要产生新的java文件,那么这个时候需要将该目录复制到*/myclass/*目录下的相应位置,否则会报告找不到class的错误.将个性化导入到EBS设置jpximport.bat所在的位置该位置为jdeveloper安装位置的的*jdevbinoaextbin目录下可以使用set PATH=D:EF DISKEoafp6509325_R12_GENERICjdevbinoaextbin;%PATH%来设置，但是该设置是临时的，如果避免下一次再次设置，应该将D:EF DISKEoafp6509325_R12_GENERICjdevbinoaextbin;添加到环境变量。上传文件1. 将*/myprojects/hand文件夹上传到服务器$JAVA_TOP/下2. 将*/myclasses/hand 文件夹上传到服务器$JAVA_TOP/下前者是为了方便维护者查看源代码使用，后者是被用来执行的java可执行字节码.class文件。3. 在dos执行导入命令jpximport D:EF DISKFtoolsOAFp6509325_R12_GENERICjdevhomejdevmyprojectsOAFPAGE.jpx -username apps -password apps -dbconnection (description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host = )(port = 1521)(connect_data = (sid = PROD)4. 查看导入结果如果出现如图的Import completed successfully， 那么就成功了，去页面看看结果吧。查看部署效果替换VO添加客户化属性(VO基于SQL的版本)(概要)为了避免啰嗦直接从不一样地方开始讲,而且基于SQL的VO比基于EO的VO添加属性还要简单些.继承VO添加字段selectrequest_id, program, requested_start_date, UserPhase, SswaStatus, phase_code, 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) as republish,CUX_OAF_TEST_F(program) AS FRANKADDfrom(select request_id, program, requested_start_date, fnd_conc_sswa.get_phase(phase_code, status_code, hold_flag, enabled, requested_start_date, request_id) as UserPhase,decode(fnd_conc_sswa.get_sswa_status(phase_code, status_code, hold_flag, enabled, requested_start_date, request_id),C,Fndcpnormalicon, G, Fndcpwarningicon, E, Fndcperroricon, H,Fndcponholdicon,NULL) as SswaStatus,phase_code, requested_by, responsibility_application_id