How to check online FND_USERS in Oracle Apps
July 1, 2017
AppsDBA Scripts, Scripts
How to check online FND_USERS in Oracle EBS R12
SELECT DISTINCT icx.session_id,
icx.user_id,
fu.user_name,
fu.description
FROM icx_sessions icx,
fnd_user fu
WHERE disabled_flag != ‘Y’
AND icx.pseudo_flag = ‘N’
AND ( last_connect + Decode (fnd_profile.Value (‘ICX_SESSION_TIMEOUT’),
NULL,
limit_time,
0
,
limit_time,
fnd_profile.Value (‘ICX_SESSION_TIMEOUT’)
/
60) / 24 ) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id
Related Posts