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
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:
Good information, thanks for sharing this blog.
Oracle Fusion HCM Online Training
Post a Comment