Technology Stack - EBS (MOSC)

MOSC Banner

fnd_profile.value_specific not giving proper results.

edited Aug 20, 2021 11:34AM in Technology Stack - EBS (MOSC) 1 commentAnswered

1)Org_ID = 243 (In Profile it is I did set to 'Y" however when I ran the below query it returns 'Y

select fnd_profile.value_specific('XXBG_ICX_RECEIVE_GOODS1',NULL,NULL,NULL,243,NULL) from dual;

2)Org_id = 192(In profile I did  is set to 'N') however below query returning wrong result Y

select fnd_profile.value_specific('XXBG_ICX_RECEIVE_GOODS1',NULL,NULL,NULL,192,NULL) from dual;

Not sure why this value_specific returning strange results. I think I have to use select statement to get the required output and the standard funcion provided by oracle did no work. any inputs would be good.

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