for check ebs 12.2 active user connection, we need connect to database of this ebs app, and running sql follow:
/* Formatted on 8/30/2018 11:47:28 AM (QP5 v5.252.13127.32867) */
SELECT ( (SELECT SYSDATE FROM DUAL)),
(SELECT ' user sessions : ' || COUNT (DISTINCT session_id)
How_many_user_sessions
FROM icx_sessions icx
WHERE disabled_flag != 'Y'
AND 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 counter < limit_connects)
FROM DUAL;