Total Pageviews

Showing posts with label EBS : Forms Personalization. Show all posts
Showing posts with label EBS : Forms Personalization. Show all posts

Wednesday, 26 April 2023

EBS : Forms Personalization : Special Trigger Notes

 EBS : Forms Personalization : Special Trigger Notes


You can enable SPECIAL1-15 or MENU1-15, to create new menu entries under the Tool menu. The above two setups have instantiated the new Menu Items SPECIAL16-30 will create entries under Reports menu SPECIAL31-45 will create entries under Actions menu

Sunday, 23 May 2021

Oracle Apps Query : Form Personalization related query

 

1) Form Personlization header table

select  rule_key,function_name,sequence ,rule_type,enabled,a.* 

from fnd_form_custom_rules a 

where form_name ='APXINWKB'



2) Form Personalization Action Table

select id, rule_key,function_name,a.sequence ,rule_type,TRIGGER_EVENT, trigger_object,b.*  

from  fnd_form_custom_rules a  ,FND_FORM_CUSTOM_ACTIONS b

where a.ID = b.RULE_ID 

and form_name ='APXINWKB'

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...