EBS Customizations (MOSC)

MOSC Banner

fnd_proile.value('USER_ID') and fnd_global.user_id not returning correct value

edited Jun 12, 2013 4:36AM in EBS Customizations (MOSC) 4 commentsAnswered
Hi

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;

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