Skip to content

Instantly share code, notes, and snippets.

@jramb

jramb/ebs-logged-in-users.sql

Last active June 15, 2023 20:49
Show Gist options
  • Save jramb/5280077 to your computer and use it in GitHub Desktop.
Save jramb/5280077 to your computer and use it in GitHub Desktop.
Download ZIP
List all users currently logged in on Oracle EBS.This select lists all users currently logged in (only potentially, since they might have ended the session without loggin out).
Raw
ebs-logged-in-users.sql
select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.*
from apps.icx_sessions icx
join apps.fnd_user usr on usr.user_id=icx.user_id
left join apps.fnd_responsibility resp on resp.responsibility_id=icx.responsibility_id
where last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24
and disabled_flag != 'Y' and pseudo_flag = 'N'
@moussabderrahim
Copy link

Thank you for the query, just you should add the following line at the end to exclude disconnected sessions :
AND USER_NAME <>'GUEST'

Regards,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment