|
|
Dear Erman,
We are using below sql to check the current users logged into out erp system.Why are we seeing guest in below output.
SQL> SELECT icx.first_connect,last_connect, usr.user_name,usr.DESCRIPTION, resp.responsibility_key, function_type
2 FROM apps.icx_sessions icx JOIN apps.fnd_user usr ON usr.user_id = icx.user_id
3 LEFT JOIN apps.fnd_responsibility resp
4 ON resp.responsibility_id = icx.responsibility_id
5 WHERE last_connect > SYSDATE - NVL (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'), 30) / 60 / 24
6 AND disabled_flag != 'Y'
7 AND pseudo_flag = 'N';
FIRST_CONNECT LAST_CONNECT
------------------ ------------------
USER_NAME
--------------------------------------------------------------------------------
RESPONSIBILITY_KEY FUNCTION_TYPE
------------------------------ ------------------------------
25-MAR-20 25-MAR-20
17478
XXORA_PAYABLES_AAO_OFFICER FORM
25-MAR-20 25-MAR-20
GUEST
guest
Thank you
|
Locked
