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內(nèi)容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中的開發(fā)步驟細(xì)節(jié)，總結(jié)自己曾遇到的問題點。內(nèi)容l 利用AD_DD工具包注冊表l FORM中添加DF項l 啟用DF項及運行FORM（一）利用AD_DD工具包注冊表在AD_DD工具包中包含了將表注冊到系統(tǒng)中的代碼，可以利用hand_plsql_autocreate自動生成腳本，copy到命令窗口運行，即可完成注冊。1. DFF開啟的前提表中含有ATTRIBUTE的16個字段。2. 利用腳本注冊利用hand_plsql_autocreate生成注冊腳本。將生成的代碼copy到命令窗口執(zhí)行。注冊成功。記得提交事務(wù)3. 系統(tǒng)中注冊保存后點擊列，可看到已啟用彈性域字段。4. 在

10、注冊表時如果出錯了怎么辦？此前在建表時因為是手動建的，失誤將last_update_date寫成了last_updated_date,之后在發(fā)現(xiàn)這個錯誤并將此字段改回時，重新注冊表，在這個字段處報錯了，提示違反唯一性約束，讓我想到可能是因為在之前注冊過錯誤的字段的原因。所以可以找到這個表，刪除錯誤信息。查看AD_DD包，可以看到，注冊主要是insert相關(guān)表和字段的信息到fnd_tablesfnd_columns兩張表中執(zhí)行以下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');將其中錯亂數(shù)據(jù)刪除（或者直接將這個表對

12、應(yīng)數(shù)據(jù)全部刪除）提交事務(wù)再次注冊即可成功。（二）FORM中添加DF項1. 添加DF項名稱DF子類信息TEXT_ITEM_DESC_FLEX數(shù)據(jù)庫項否畫布AUTOMATION_MAP_STACKED數(shù)據(jù)塊堆疊畫布X坐標(biāo)0Y坐標(biāo).25提示NULL2. COPY DF到提示塊名稱DF子類信息FOLDER_PROMPT_MULTIROW初始值 數(shù)據(jù)庫項否畫布AUTOMATION_MAP_STACKED數(shù)據(jù)塊堆疊畫布X坐標(biāo)0Y坐標(biāo)03. 數(shù)據(jù)塊DF項添加item級觸發(fā)器WHEN-NEW-ITEM-INSTANCEFND_FLEX.EVENT('WHEN-NEW-ITEM-INSTANCE'

13、;);執(zhí)行層次：BEFOREWHEN-VALIDATE-ITEMFND_FLEX.EVENT('WHEN-VALIDATE-ITEM');4. 添加或修改block級觸發(fā)器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級觸發(fā)器WHEN-NEW-FORM-INSTANCE中初始化代碼添加初始化代碼：-define descriptive flexfield fnd_descr_flex.define(block => 'AUTOMATION_MAP'數(shù)據(jù)塊名, field => 'DF'彈性域字段, appl_short_name => 'XXINV'注冊應(yīng)用,desc_flex_name => 'XXINV_AU

15、TOMATION_MAP'彈性域名);至此，F(xiàn)ORM中設(shè)置完結(jié)。（三）啟用DF及運行FORM1. 啟用DF搜索應(yīng)用及標(biāo)題，點擊段。新建一條，輸入名稱、提示，選擇一個彈性域字段作為列，點擊保存，點擊確定，之后選擇打開。當(dāng)然這里面還可以啟用更多的彈性域字段。取消選擇必需，保存。返回，取消顯示選項，勾選凍結(jié)彈性域定義，點擊確定，保存后OK。2. 運行FORM查看結(jié)果至此，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