E-Business Suite users currently login per module
                                                 Last update (2010-11-01 10:47:45)
                                                                                                                   Date added (2008-02-18 12:18:22)

Summary
You can find the users currently using the modules of E-Business Suite. For example to find the distinct currently connected users to all the TeleSales modules.
SELECT ROWNUM num, A.* FROM 
(SELECT DISTINCT usr.user_name apps_user, apps.application_short_name module, 
apps_tl.application_name, TRUNC(l.start_time) login_time
FROM applsys.fnd_logins l, applsys.fnd_application apps, applsys.FND_APPLICATION_TL apps_tl, 
applsys.fnd_login_responsibilities lresp, applsys.fnd_login_resp_forms lform, 
applsys.fnd_responsibility resp, applsys.fnd_form frm, applsys.fnd_user usr, v$process vproc, v$session s 
WHERE l.login_id = lresp.login_id (+) 
AND l.login_id = lform.login_id (+) 
AND apps.application_id (+) = resp.application_id
AND apps.application_id = apps_tl.application_id
AND l.user_id = usr.user_id 
AND lresp.responsibility_id = resp.responsibility_id (+) 
AND lresp.responsibility_id IS NOT NULL
AND lresp.resp_appl_id = resp.application_id (+) 
AND lform.form_id = frm.form_id (+) 
AND lform.form_appl_id = frm.application_id (+) 
AND l.end_time IS NULL 
AND lresp.end_time IS NULL 
AND lform.end_time IS NULL 
AND l.spid = s.process 
AND vproc.addr = s.paddr (+)
--AND l.login_name = s.osuser  
--AND s.process = '29085'
--AND USR.USER_NAME like 'SYS%'
--AND s.machine = 'ecapps1'
) A WHERE application_name LIKE 'Tele%'
AND login_time = TRUNC(SYSDATE)
--WHERE apps_user = 'KAPARELIS';
If you don't remember Application Name of the module you can query
SELECT * FROM applsys.FND_APPLICATION_TL 
WHERE application_name LIKE 'Tele%';
Reviews
Filters
Search