Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog Post

How to check online FND_USERS in Oracle Apps

How to check online FND_USERS in Oracle Apps

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
Write a comment