Technology Stack - EBS (MOSC)

MOSC Banner

How to get number of users connected through frontend -- Oracle Apps

edited Aug 20, 2021 10:48AM in Technology Stack - EBS (MOSC) 4 commentsAnswered ✓
 Hi,
My oracle apps version is: 11.5.10

Can you provide any query that provides total number of connected users(through frontend application) at that moment.

I have some queries like:

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
order by 4; 

Is this correct?

Or if there are better ways to confirm this?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center