SID AND SERIAL# OF APPLICATION USER :

lOGIN TO SYSADMIN NAVIGATE TO :

SECURITY USER -- MONITOR --

CHECK ORACLE PROCESS-ID

IF UNABLE TO SEE USERS -- SET PROFILE OPTION SIGN ON AUDIT TO FORM LEVEL

SAVe

SELECT SUBSTR(d.user_name,1,30) "User Name",a.pid,b.sid,b.serial#

FROM v$process a, v$session b, fnd_logins c, fnd_user d

WHERE a.pid = c.pid

AND c.pid = &PID

AND d.user_name = UPPER('&USER_NAME')

AND TO_DATE(c.start_time) = TO_DATE('&START_DATE')

AND d.user_id = c.user_id

AND a.addr = b.paddr

AND c.end_time IS NULL;

2) When prompted for "PID" enter the value that appears under the Oracle Process column on the form.

3) When prompted for "USER_NAME" enter the value that appears under the User Name column on the form.

4) When prompted for "START_DATE" enter the Date that the user started the session.

Another way to get this info is through OAM:

- Login to OAM

- Navigate to Site Map > Monitoring > Forms Sessions

- Click on "Session Details"