Oracle eBS經驗分享

我們一般在建立一個簡單的Tabular Form的做法如下:

首先我先建立一個View for Query(F11)使用

In general, complex blocks are based on views while simple setup
blocks are based on tables.

透過View來呈現資料是比較簡單的方式:(節錄於Oracle Applications Developer’s Guide)

1. 1.Network traffic is minimized because all foreign keys are denormalized on the server
2. 2.You do not need to code any POST–QUERY logic to populate non–database fields
   3.You do not need to code PRE–QUERY logic to implement query–by–example for non–database fields

[Query Data Souce Name] : View Name

[DML Data Target ]

Column 上的設定

DML Table Column - 要設定一個Primiary Key Column

Non DML Table Column Setting

ps. 此Column 要能夠讓User 從 LOV選擇，並儲存 ID 值到DML table中

注意:如果Column是要Query by view, 但寫入時不寫入DML Table的，其property中”Query Only”要設定成”Yes”(如下圖)