It depends on what kind of sign on audit level was set in the system. If
you have sign on audit level set to form level then you can use the
following query, this is basically taken from the monitor users form and
tweaked.

- Suresh

SET PAGESIZE 9999 VERIFY off FEEDBACK off LINESIZE 132
COLUMN uname HEADING 'User Name' FORMAT A12;
COLUMN shrtnam HEADING 'Application' FORMAT A11;
COLUMN respnam HEADING 'Responsibility' FORMAT A14;
COLUMN frmnam HEADING 'Form' FORMAT A10;
COLUMN pid HEADING 'Oracle|PID' FORMAT 999999;
COLUMN sid HEADING 'Oracle|SID' FORMAT 999999;
COLUMN sn HEADING 'Session|S/N' FORMAT 999999;
COLUMN spid HEADING 'Server|Process' FORMAT 9999999;
COLUMN suser HEADING 'Client|OS User' FORMAT A8;
COLUMN process HEADING 'Client|Process' FORMAT A8;
COLUMN smach HEADING 'Client|Machine' FORMAT A8;
COLUMN sprog HEADING 'Program' FORMAT A15
WORD_WRAPPED;
-- COLUMN cli HEADING 'Client|Info' FORMAT A15
WORD_WRAPPED;
SELECT usr.user_name uname,
app.application_short_name shrtnam,
resp.responsibility_name respnam,
form_name frmnam,
vproc.pid pid,
vsess.sid sid,
vsess.serial# sn,
vproc.spid spid,
vsess.osuser suser,
vsess.process process,
vsess.machine smach,
vsess.program sprog
FROM applsys.fnd_logins l,
applsys.fnd_application app,
applsys.fnd_login_responsibilities lresp,
applsys.fnd_login_resp_forms lform,
applsys.fnd_responsibility_tl resp,
applsys.fnd_form frm,
applsys.fnd_user usr,
v$process vproc,
v$session vsess
WHERE l.login_id = lresp.login_id (+)
AND l.login_id = lform.login_id (+)
AND app.application_id (+) = resp.application_id
AND l.user_id = usr.user_id
AND lresp.responsibility_id = resp.responsibility_id (+)
AND lresp.resp_appl_id = resp.application_id (+)
AND lform.form_id = frm.form_id (+)
AND lform.form_appl_id = frm.application_id (+)
AND lresp.end_time IS NULL
AND lform.end_time IS NULL
AND vproc.addr = vsess.paddr
AND l.spid = vsess.process
AND l.pid = vproc.pid
AND ( l.pid, l.start_time ) IN ( SELECT pid, MAX(start_time)
FROM applsys.fnd_logins
WHERE end_time IS NULL
AND terminal_id != 'Concurrent'
GROUP BY pid )
ORDER BY vproc.pid;

-----Original Message-----
From: Jolene E Shrake
[mailto:oracledba-ezmlmshield-x32866786.[Email address protected]
Sent: Monday, August 01, 2005 12:26 PM
To: LazyDBA Discussion
Subject: Oracle Forms sessions 11.5.9

Does any one have a query to find the current forms users and what form
they are using?

This is Oracle Apps 11.5.9.

Thanks,
Jolene
586-825-5977 (office)
586-588-1897 (cell)


------------------------------------------------------------------------
----------------
This is a PRIVATE message. If you are not the intended recipient, please

delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use
of
e-mail for such purpose.
------------------------------------------------------------------------
----------------


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page