Is there a way to review Oracle application user Toad? (4225561)

Is there a way to review Oracle application user Toad? I'm trying to sort and review my Oracle apps users in the Session Browser in Toad, but there does not seem to be an option for this.

Oracle apps stores the application users somewhere in the APPS schema and is not accessed by the Session Browser.

There is no option for Oracle Apps users.

Features to access and review Oracle apps are included in the Ebiz module but that has been discontinued as Of January 31, 2009. If you already have a license for Ebiz and have an older version of Toad installed you can check under Activity -> Sessions for info about your users.

If you do not have Ebiz, herr's the query:

SELECT s.sid,
s.serial#,
s.machine,
s.module,
decode( processes.user_name|| self_service.self_service, null, s.osuser,
processes.user_name|| self_service.self_service ),
decode( modules.module_type, null, null, modules.module_type||': '||modules.user_module_name ),
decode(managers.user_concurrent_queue_name, null, s.program, managers.user_concurrent_queue_name ) ,
s.osuser,
s.process,
s.logon_time,
(consistent_gets + block_gets),
processes.pid ,
processes.spid
FROM v$session s,
v$sess_io io,
( SELECT distinct
p.addr,
p.pid,
p.spid,
p.username,
p.serial#,
p.terminal,
p.program,
fu.user_name
FROM apps.fnd_v$process p,
applsys.fnd_logins fl,
apps.fnd_user fu
WHERE p.spid = fl.spid(+)
and fl.user_id = fu.user_id ) processes,
( SELECT 'FORM' module_type,
ff.application_id,
fat.application_name,
ff.form_id,
ff.form_name module_name,
fft.user_form_name user_module_name
FROM applsys.fnd_form ff,
applsys.fnd_form_tl fft,
applsys.fnd_application_tl fat
WHERE ff.application_id = fft.application_id
and ff.form_id = fft.form_id
and ff.application_id = fat.application_id
and fft.language = userenv('LANG')
and fat.language = userenv('LANG')
UNION ALL
SELECT 'CONC REQUEST',
fcp.application_id,
fat.application_name,
fcp.concurrent_program_id,
fcp.concurrent_program_name,
fcpt.user_concurrent_program_name
FROM applsys.fnd_concurrent_programs fcp,
applsys.fnd_concurrent_programs_tl fcpt,
applsys.fnd_application_tl fat
WHERE fcp.application_id = fcpt.application_id
and fcp.concurrent_program_id = fcpt.concurrent_program_id
and fcp.application_id = fat.application_id
and fcpt.language = userenv('LANG')
and fat.language = userenv('LANG') ) modules,
( SELECT fcq.concurrent_queue_name,
fcqt.user_concurrent_queue_name,
fcpr.os_process_id,
fcpr.concurrent_process_id
FROM applsys.fnd_concurrent_queues fcq,
applsys.fnd_concurrent_processes fcpr,
applsys.fnd_concurrent_queues_tl fcqt
WHERE fcq.application_id = fcpr.queue_application_id
and fcq.concurrent_queue_id = fcpr.concurrent_queue_id
and fcq.application_id = fcqt.application_id
and fcq.concurrent_queue_id = fcqt.concurrent_queue_id
and fcpr.process_status_code = 'A'
and fcqt.language = userenv('LANG')) managers,
( SELECT distinct '(SS)' self_service,
fas.audsid
FROM applsys.fnd_appl_sessions fas ) self_service
WHERE s.paddr = processes.addr(+)
and s.serial# ! = 1
AND s.sid = io.sid
and s.inst_id = io.inst_id
and s.module = modules.module_name(+)
and s.process = managers.os_process_id(+)
and s.audsid = self_service.audsid(+)

Notification for Discontinued Support of Toad for Oracle e-Business Module:

https://support.quest.com/SUPPORT/index?page=displayNotification&id=02484d2af20117edeca6d30071b2&pmv=true&ct=1