Thứ Tư, 29 tháng 8, 2018

EBS 12.2 active user connection

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;