ERPstuff - Oracle EBS Community

what query can i use to trace the apps users

Currently the query i use, it returns username as apps for all of them
I want to know the logged in user name

Your help is appreciated

Thanks

query v$sessions

if you just want to know user who currently login then you can use system administration too

Hi ,
Use below query to know about users logged in apps

select distinct d.user_name from apps.fnd_logins a,
v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = 'USER_NAME' OR 1=1);

bye