Total Pageviews

September 22, 2016

9/22/2016 02:54:00 AM
Query find window in Oracle apps
Oracle Apps Forms Query Find window

1.create a table in particular module.

2.grant the table to apps.
3.create synonym for the table.
4.download template.fmb and appstand.fmb from    au_top/resources to local machine using    ftp.
5.rename template.fmb and open it in   formbuilder.
6.open appstand.fmb in the same form.

7.copy query-find from appstand object group to template object group.

8.delete blockname in canvas,windows,datablock level.
9.create new canvas,window,datablock using create button.
10.   (i)select query_find datablock.select new button trigger        -->change block name
    (ii)select find button trigger -->change block name
    (iii)go to main datablock select item to query paste it in           query_find block items 
     (iv)select copied item properties change canvas name.

11.select main_block triggers create pre_query_trigger

     inside the trigger type 
     if :parameter.g_query_find = 'true' then
     copy(:query_find_block.item,'main_block.item');
     :parameter.g_query_find := 'false';
     end if; 

12.create one more trigger at same blocklevel


     triggername is user_named

     inside the trigger type app_find.query_find('main_window','query_find_window',
     'query_find_block');

13.select lov block create lov.


14.attach lov to query_find item in query_find_datablock.


15.select module level trigers customize     pre-form,when-new-form-instance trigger  and app_cust     package_body


16.execute usernamed trigger in when-new-form-instance      trigger by using execute_trigger('TRIGGER_NAME');


17.save the form and tranfer fmb to custom_top.


18.generate formexecutable(fmx) using the unix command 

     f60gen module = formname.fmb username/password.

19.transfer fmx to particular module_top/forms folder.


20.log on to oracle apps select applicationdeveloper resp.


21.create form.


22.create function,attach form to function.


23.create menu ,attach function to menu.


24.define responsibility,attach menu to resp.


25.attach resp to user.