R12 active users

Log in to system as apps users via oracle SQL developer or command prompt then issue below quarries  for the active users

Query to check Active users 

sqlplus apps/apps

select fnd.user_name, icx.responsibility_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
where
fnd.user_id = icx.user_id
and icx.responsibility_id = frt.responsibility_id
and icx.disabled_flag <> 'Y'
and trunc(icx.last_connect) = trunc(sysdate)
order by icx.last_connect; 

output shotud be as below

user11111    0    50571    Application Diagnostics    953037305    29-JUL-13    29-JUL-13    ACTIVE

user1223     1    20420    System Administrator    1778536210    29-JUL-13    29-JUL-13    ACTIVE