Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fnd_profile value

1026501Jul 19 2013 — edited Jul 22 2013

Hi guys,

Can anyone help me in capturing the function id & form id from Apps front end...

SELECT fnd_profile.VALUE ('FORM_ID')

     FROM DUAL;

  

SELECT  fnd_profile.VALUE ('FUNCTION_ID')

     FROM DUAL;

I used the above query in my Pl/sql function .. But when try to retrieve this function and form id i'm getting null value..

I'm able to retrieve the responsibility id .. Is there any alternative way to fetch the form id & function id... Appreciate your help...

Regards,

Archana

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2013
Added on Jul 19 2013
5 comments
6,712 views