fnd_profile.value_specific not giving proper results.
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.