Technology Stack - EBS (MOSC)

MOSC Banner

Getting null for custom profile in fnd_profile.value('XXcustomsecurity')

edited Aug 20, 2021 11:24AM in Technology Stack - EBS (MOSC) 2 commentsAnswered
Hi,
We are in 12.1.3

I have created new custom profile 'XXcustomsecurity'.
However, i could not get the profile value using fnd_profile.value and getting null value in our custom package


Also tried with assigning this profile value in select clause and not getting the profile value (returns null).

Ex:

select * from XX_mcd where org_id=fnd_profile.value('XXcustomsecurity');

Here fnd_profile.value('XXcustomsecurity') returns null.


Regards

Vinod

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center