Oracle eBS經驗分享

開發經驗紀錄

1. Download TEMPLATE.fmb,APPSTAND.fmb from Oracle AP server

2. Rename TEMPLATE.fmb to your form name *ex.XXX.fmb)

3. New window object "DOCUMENTS_WINDOW"

4. Modify APP_CUSTOMS program unit procedure close_window..

if (wnd = 'DOCUMENTS_WINDOW') then
  app_window.close_first_window;
elsif (wnd = '<another window>') then
  --defer relations
  --close related windows  
  null; 
elsif (wnd = '<yet another window>') then
  --defer relations
  --close related windows  
  null;
end if;

Note: If base table is a view , you need to assign fact table name to “DML table”column in Block property.

6. Must modify form level [PRE-FORM] trigger at form level

app_window.set_window_position('DOCUMENTS_WINDOW', 'FIRST_WINDOW');

7. Design your layout

8. Copy Query_Find object group to current XXX.fmb from APPSTAND.fmb

Copy Query_Find Object group and paste to XXX.fmb

==>當User 在EBS select  [Help]> [About Oracle Applications]就可以看到上面資訊

4. “KEY-NXTBLK”Trigger

5. Add new trigger name QUERY_FIND in result block

add a new Trigger QUERY_FIND into result block

==

APP_FIND.QUERY_FIND(‘DEPT_WINDOW’, ‘QUERY_FIND’,'QUERY_FIND’);