fnd_proile.value('USER_ID') and fnd_global.user_id not returning correct value
We are trying to use fnd_profile.value and FND_GLOBAL package to get currentUSER_ID, RESP_ID, RESP_APPL_ID in PLSQL DB Procedure which is being executed in shell script which is registered as concurrent program
SELECT fnd_profile.value('USER_ID') into v_user_id FROM dual;
SELECT fnd_profile.value('RESP_ID') into v_resp_id FROM dual;
SELECT fnd_profile.value('RESP_APPL_ID') into v_resp_appl_id FROM dual;
above profile options are returning null value
v_user_id:=FND_GLOBAL.USER_ID;
v_resp_id:=FND_GLOBAL.RESP_ID;
v_resp_appl_id:=FND_GLOBAL.RESP_APPL_ID;