POiSON WORLD

Run the following query to find out who are the Oracle Apps Users currently Logged into the application.

  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;

Comments

comments

Tags: Current Login Users, Current Login Users List In Oracle EBS R12 11i, Oracle Current Login Users List

This entry was posted on Sunday, January 23rd, 2022 at 12:01 am and is filed under Oracle EBS Application, Oracle Queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.