Thursday, 6 February 2014

Identify the front-end apps session details for a back-end process.

Identify the front-end apps session details for a back-end process.
set linesize 400
column user_name format a30
column user_form_name format a30
column responsibilty_name format a30
select user_name,TIME,user_form_name,responsibility_name from apps.FND_SIGNON_AUDIT_VIEW where pid in
(select pid from v$process where spid=&SPID;

No comments: