EBSForm个性化详解及开发实例word原版

OracleE-BUSINESSSUITER12Form个性化详解及开发实例Author:曹正炎Zhenygan.CaoCreationDate:January15,2013LastUpdated:March23,2020DocumentRef:DocumentReferenceNumberVersion:DRAFT1AApprovals:Approver1Approver2CopyNumber_____OracleOracleForm个性化开发FileRef:1584968716884(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyDocRef:DocumentReferenceNumberJanuary18,2013Form个性化iiDocumentControlChangeRecord3DateAuthorVersionChangeReference2013/1/15Zhengyan.CaoDraft1aNoPreviousDocumentReviewersNamePositionDistributionCopyNo.NameLocation1234NoteToHolders:Ifyoureceiveanelectroniccopyofthisdocumentandprintitout,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.Ifyoureceiveahardcopyofthisdocument,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.OracleOracleForm个性化开发FileRef:1584968716884(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyDocRef:DocumentReferenceNumberJanuary18,2013Form个性化iiiContentsDocumentControl..................................................................................................................iiPreface......................................................................................................................................11.个性化基础............................................................................................................................21.1.概述......................................................................................................................21.2.启用......................................................................................................................21.3.个性化设置界面..................................................................................................31.4.四种活动类型介绍..............................................................................................51.5.赋值规则..............................................................................................................71.6.迁移及异常处理..................................................................................................81.7.CUSTOM.PLL....................................................................................................91.8.CUSTOM.PLL祥解..........................................................................................112.个性化项目实例.......................................................................................................152.1.特性活动类型个性化........................................................................................152.2.消息活动类型个性化........................................................................................182.3.内置活动类型个性化(DO_KEY).....................................................................192.4.菜单活动类型个性化........................................................................................192.5.个性化客制LOV(内置:根据查询创建记录组)................................................202.6.个性化增加Weblink(内置:启动URL).............................................................212.7.个性化插入or更新数据库(内置:FORMS_DDL).............................................222.8.个性化调用并发请求(内置:启动SRS表单)...................................................232.9.个性化调用并发请求(内置:执行过程)............................................................252.10.个性化调用Form界面(内置:启动功能)..........................................................283.CUSTOM.PLL项目实例.........................................................................................303.1.属性案例............................................................................................................303.2.小案例................................................................................................................313.3.调用并发请求并弹出请求Form界面...............................................................324.OpenandClosedIssuesforthisDeliverable......................................................36OpenIssues.....................................................................................................................36ClosedIssues..................................................................................................................36Preface有时客户会要求我们对标准功能做一些改动，如果不是重大的修改的话，我们都不希望去动标准form，那么个性化为我们提供了一个很好的手段。根据EBS版本不同，form个性化也会有一些区别。但是我们能使用的action还是基本相同的，包括特性，内置，消息和特殊（或是菜单）。主要有改变item等对象的属性或值，定义SPECIAL，显示消息，打开功能等等。本文档基于EBS12.1.3。OracleOracleForm个性化开发FileRef:1584968716884(v.DRAFT1A)CompanyConfidential-ForinternaluseonlyDocRef:DocumentReferenceNumberJanuary18,2013Form个性化2of391.个性化基础1.1.概述Form个性化(FormPersonalization)允许您修改基于Form基础页面的事件，包括：修改物件的属性、执行内建函数、产生提示信息和添加标签入口。对于每个功能（需在功能处指定上下文条件，相应的Form才能执行）来说，您可以制定一个或一个以上的规则。每条规则包括：一个事件，事件执行的条件（可选），事件执行的范围，一个或多个动作。Form上的一个Trigger就是一个事件。例如，开启页面的Trigger(WHEN-NEW-FORM-INSTANCE)，或者光标从一条记录移至另一条新的记录所触发的Trigger（WHEN-NEW-RECORD-INSTANCE）等等，这几乎是每个Form传送资料都必须执行的，或者确认传送资料附加的事件。若指定了事件执行的范围，当Form在运行的时候，系统会去检查当前的规则是否可执行。事件执行的范围有以下层级：Site、Resoponsibility、User、Industry，每个规则可有相应层级的执行范围与之相关联。（注：Industry层级的执行范围指的是为下一版本预留。）事件执行的条件是一段SQL语句，来控制事件在何时执行。只有在执行条件的返回结果是真时，该时间才会执行。一个动作包含以下的任意一项内容：a.设置属性，如：设置一个栏位状态为必输，隐藏一个Tab页签等。b.执行内建函数，如：GO_BLOCK，DO_KEY，FND_FUNCTION.EXECUTE等。c