How to get User id , User name From Current login Information in Oracle Ebs.

User_NNH9P

How to get User id , User name From Current login Information in Oracle Ebs.

LPNO

You mean Oracle OEBS (Oracle E-Business Suite alias Oracle Applications)?

Then this query would cover this

select last_connect, usr.user_name, icx.user_id,per.FULL_NAME FULL_NAME, resp.responsibility_key, function_type  from apps.icx_sessions icx,  PER_PEOPLE_F per, fnd_user usr, fnd_responsibility resp   where         usr.user_id=icx.user_id        and usr.EMPLOYEE_ID = per.PERSON_ID                and icx.responsibility_id = resp.responsibility_id          and last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24        and disabled_flag != 'Y' and pseudo_flag = 'N';

Robert Angel

see also the package fnd_global, which has fnd_global.user_id / fnd_global.user_name (amongst others) - if you are looking for the environment variables that are initialised on log in.

jaramill

FYI - The EBS forum is here --> for questions regarding EBS

Robert Angel

It does tend to be more functional and less technical (from my experience) though...

jaramill

Robert Angel wrote:It does tend to be more functional and less technical (from my experience) though...

Understood.  Don't have any experience with any Oracle applications such as ERP, CRM, EBS, etc...whole other world.  Thanks for the tip.

User_NNH9P

Thank you...

I am getting the Output, but the data coming out is not accurate. Can you please suggest the correct condition which can be used to get the accurate data , when the user login Oracle Ebs i have to capture the data

Robert Angel

Try adding; -

and icx.user_id = fnd_global.user_id

to the sql statement previously suggested.

User_NNH9P

Sorry,

But it didn't worked :-(

NAVEENKUMAR SEERANGAN

Oracle SYS_CONTEXT Function

SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER')

   FROM DUAL;

   SELECT sys_context('USERENV', 'MODULE'),

         sys_context('USERENV', 'TERMINAL')

 

    FROM dual;

   

    SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER')

   FROM DUAL;

User_NNH9P

This query is giving data for the BACKEND user login not the Front Oracle Ebs