Last active
June 15, 2023 20:49
-
-
Save jramb/5280077 to your computer and use it in GitHub Desktop.
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).
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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' |
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
Added meaningful default in case ICX_SESSION_TIMEOUT is not set