ORACLE 实践 FORM DFF(描述性弹性域)

1、Doc Ref: Error! Reference source not found.Error! Reference source not found.July 21,2016Oracle实践 FORM DFF（描述性弹性域）实践Author:张翔龙Xianglong.ZhangE-Mail: xianglong.zhanghand-Creation Date:July 21, 2016Last Updated:July 21, 2016Document Ref:Error! Reference source not found.Version:1.0Note: Title, Subject

2、, Last Updated Date, Reference Number, and Version are marked by a Word Bookmark so that they can be easily reproduced in the header and footer of documents. When you change any of these values, be careful not to accidentally delete the bookmark. You can make bookmarks visible by selecting Tools->

3、;OptionsView and checking the Bookmarks option in the Show region.Approvals:<Approver 1>Xianglong.Zhang<Approver 2>Copy No._Note: To add additional approval lines, press Tab from the last cell in the table above.Note: You can delete any elements of this cover page that you do not need fo

4、r your document. For example, Copy Number is only required if this is a controlled document and you need to track each copy that you distribute.Document ControlChange Record3DateAuthorVersionChange Reference2016-7-21Xianglong.Zhang1.0No Previous DocumentReviewersNamePositionDistributionCopy No.NameL

5、ocation1Library MasterProject Library2Project Manager34Note: The copy numbers referenced above should be written into the Copy Number space on the cover of each distributed copy. If the document is not controlled, you can delete this table, the Note To Holders, and the Copy Number label from the cov

6、er page.Note To Holders:If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.If you receive a hard copy of this document, please write your name on the front cover, for document control purposes

7、.ContentsDocument Controlii总体说明1文档目的1内容1（一）利用AD_DD工具包注册表2（二）FORM中添加DF项6（三）启用DF及运行FORM9Open and Closed Issues for this Deliverable12Open Issues12Closed Issues12Note: To update the table of contents, put the cursor anywhere in the table and press F9. To change the number of levels displayed, select th

8、e menu option Insert>Index and Tables, make sure the Table of Contents tab is active, and change the Number of Levels to a new value.Open and Closed Issues for this Deliverable 12Error! Reference source not found.File Ref: ORACLE FORM DFF实践.doc (1. 0 )Company Confidential - For internal use only总

9、体说明文档目的 整理在DFF中的开发步骤细节，总结自己曾遇到的问题点。内容l 利用AD_DD工具包注册表l FORM中添加DF项l 启用DF项及运行FORM（一）利用AD_DD工具包注册表在AD_DD工具包中包含了将表注册到系统中的代码，可以利用hand_plsql_autocreate自动生成脚本，copy到命令窗口运行，即可完成注册。1. DFF开启的前提表中含有ATTRIBUTE的16个字段。2. 利用脚本注册利用hand_plsql_autocreate生成注册脚本。将生成的代码copy到命令窗口执行。注册成功。记得提交事务3. 系统中注册保存后点击列，可看到已启用弹性域字段。4. 在

10、注册表时如果出错了怎么办？此前在建表时因为是手动建的，失误将last_update_date写成了last_updated_date,之后在发现这个错误并将此字段改回时，重新注册表，在这个字段处报错了，提示违反唯一性约束，让我想到可能是因为在之前注册过错误的字段的原因。所以可以找到这个表，删除错误信息。查看AD_DD包，可以看到，注册主要是insert相关表和字段的信息到fnd_tablesfnd_columns两张表中执行以下SQL可以查看到所注册的字段SELECT * from fnd_columns where application_id = (select application_i

11、d from fnd_application where application_short_name = 'XXINV') and table_id = (SELECT table_id from fnd_tables where application_id = (select application_id from fnd_application where application_short_name = 'XXINV') and table_name='XXINV_AUTOMATION_MAP');将其中错乱数据删除（或者直接将这个表对

12、应数据全部删除）提交事务再次注册即可成功。（二）FORM中添加DF项1. 添加DF项名称DF子类信息TEXT_ITEM_DESC_FLEX数据库项否画布AUTOMATION_MAP_STACKED数据块堆叠画布X坐标0Y坐标.25提示NULL2. COPY DF到提示块名称DF子类信息FOLDER_PROMPT_MULTIROW初始值 数据库项否画布AUTOMATION_MAP_STACKED数据块堆叠画布X坐标0Y坐标03. 数据块DF项添加item级触发器WHEN-NEW-ITEM-INSTANCEFND_FLEX.EVENT('WHEN-NEW-ITEM-INSTANCE'

13、;);执行层次：BEFOREWHEN-VALIDATE-ITEMFND_FLEX.EVENT('WHEN-VALIDATE-ITEM');4. 添加或修改block级触发器PRE-QUERYFND_FLEX.EVENT('PRE-QUERY');POST-QUERYFND_FLEX.EVENT('POST-QUERY');WHEN-VALIDATE-RECORDFND_FLEX.EVENT('WHEN-VALIDATE-RECORD');PRE-INSERTFND_FLEX.EVENT('PRE-INSERT');

14、PRE-UPDATEFND_FLEX.EVENT('PRE-UPDATE');5. 添加或修改FORM级触发器WHEN-NEW-FORM-INSTANCE中初始化代码添加初始化代码：-define descriptive flexfield fnd_descr_flex.define(block => 'AUTOMATION_MAP'数据块名, field => 'DF'弹性域字段, appl_short_name => 'XXINV'注册应用,desc_flex_name => 'XXINV_AU

15、TOMATION_MAP'弹性域名);至此，FORM中设置完结。（三）启用DF及运行FORM1. 启用DF搜索应用及标题，点击段。新建一条，输入名称、提示，选择一个弹性域字段作为列，点击保存，点击确定，之后选择打开。当然这里面还可以启用更多的弹性域字段。取消选择必需，保存。返回，取消显示选项，勾选冻结弹性域定义，点击确定，保存后OK。2. 运行FORM查看结果至此，DFF启用完成。 Note: If the Functional Design included a Technical Overview section, duplicate that information here a

16、nd add additional details.Note: Add other components above as requiredNote: Indicate the specific menu options added to access new forms.Open and Closed Issues for this DeliverableNote: Add open issues that you identify while writing or reviewing this document to the open issues section. As you reso

17、lve issues, move them to the closed issues section and keep the issue ID the same. Include an explanation of the resolution.When this deliverable is complete, any open issues should be transferred to the project- or process-level Risk and Issue Log (PJM.CR.040) and managed using a project level Risk and Issue Form (PJM.CR.040). In addit