Ora-01775
Please send me an e-mail Srinivasan.Venkataramani@Census.Gov as i find it very painful to search and locate the thread or document. It used to so user friendly. Its not anymore.
I ran the following script to establish the menu security :-
******************************************************************************************************
create or replace view FRM50_ENABLED_ROLES as select urp.granted_role role, or replace view FRM50_ENABLED_ROLES as select urp.granted_role role, urp.granted_role role, sum(distinct decode(rrp.granted_role, (distinct decode(rrp.granted_role, 'ORAFORMS$OSC',2, 'ORAFORMS$OSC',2, 'ORAFORMS$BGM',4, 'ORAFORMS$BGM'