Thursday, August 09, 2012

Active Form Sessions in Oracle Apps

Active Oracle Apps Form Sessions at any point of time can be know with the following query:

SELECT   fnd.user_name, icx.responsibility_application_id,
         fat.application_name, fat.application_id, icx.responsibility_id,
         frt.responsibility_name, icx.session_id, icx.first_connect,
         icx.last_connect,
         DECODE ((icx.disabled_flag),
                 'N', 'ACTIVE',
                 'Y', 'INACTIVE'
                ) status
    FROM fnd_user fnd,
         icx_sessions icx,
         fnd_responsibility_tl frt,
         fnd_application_tl fat
   WHERE fnd.user_id = icx.user_id
     AND frt.application_id = fat.application_id
     AND icx.responsibility_id = frt.responsibility_id
     AND icx.disabled_flag <> 'Y'
     AND TRUNC (icx.last_connect) = TRUNC (SYSDATE)
     AND frt.responsibility_name NOT LIKE '%Intelligence%'
ORDER BY fnd.user_name

1 comment:

yamuna said...

Good information, thanks for sharing this blog.
Oracle Fusion HCM Online Training