Concurrent request scripts

concurrent request ID, ORA_PID, ORA_SID log and output files for a given APPS REQid.txt
===========================================================================
select /*+ ORDERED */
req.request_id
, req.oracle_process_id
, ses.sid
, ses.serial#
, ses.program
, req.logfile_name log
, req.outfile_name out
from v$process pid
, v$session ses
--, apps.fnd_concurrent_processes prc
, apps.FND_CONCURRENT_REQUESTS req
where req.request_id = &request_id
--and req.controlling_manager = prc.concurrent_process_id
--and prc.CONCURRENT_QUEUE_ID = q_id
--and req.oracle_process_id IS NOT NULL
and req.oracle_process_id = pid.spid(+)
and pid.addr = ses.paddr(+)
/


display long running concurrent requests.txt
============================================
SET LINESIZE 132;
--
COLUMN request_id HEADING 'Request ID' FORMAT 99999999;
COLUMN strttime HEADING 'Start|Time' FORMAT A17;
COLUMN endtime HEADING 'End|Time' FORMAT A17;
COLUMN rtime HEADING 'Elapsed|(Min)' FORMAT 9990.99;
SELECT REQUEST_ID,
TO_CHAR(ACTUAL_START_DATE,'MM/DD/YY HH:MI:SS') strttime,
TO_CHAR(ACTUAL_COMPLETION_DATE,'MM/DD/YY HH:MI:SS') endtime,
-- ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE time,
-- TO_NUMBER(TO_CHAR(ACTUAL_COMPLETION_DATE,'JSSSSS')) - TO_NUMBER(TO_CHAR(ACTUAL_START_DATE,'JSSSSS')) seconds,
ROUND((ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE)*(60*24),2) rtime,
OUTCOME_CODE,
SUBSTR(completion_text,1,20) compl_txt
FROM fnd_concurrent_requests
-- WHERE TO_NUMBER(TO_CHAR(ACTUAL_COMPLETION_DATE,'JSSSSS')) - TO_NUMBER(TO_CHAR(ACTUAL_START_DATE,'JSSSSS')) > 3600
-- WHERE ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE > 0.01
WHERE ACTUAL_START_DATE > sysdate-10
ORDER BY 2
/


find all concurrent requests that ran for over X minutes.txt
===========================================================
set lines 300
set trims on
set pages 60
set head on
ttit off
btit off
alter session set nls_Date_format='DD-MON-RRRR HH24:MI';
accept minutes prompt "Enter runtime minutes limit to report [DEFAULT=60]: "
col runtime format 9999999 heading "Runtime|[min]"
col asd format a23 Heading "Start Time"
col acd format a23 Heading "End Time"
col cpn format a15 heading "Program"
col ucpn format a25 trunc heading "Program Name"
--col logfile_name format a85 heading "Log File" newline
--col argument_text format a300 heading "Arguments" newline
SELECT f.request_id
, TRUNC(((f.actual_completion_date-f.actual_start_date)/(1/24))*60) runtime
, f.actual_start_date asd
, f.actual_completion_date acd
, DECODE(p.concurrent_program_name,
'ALECDC',p.concurrent_program_name||'['||f.description||']'
,p.concurrent_program_name) cpn
, pt.user_concurrent_program_name ucpn
, f.phase_code
, f.status_code
--, f.logfile_name
--, f.argument_text
FROM apps.fnd_concurrent_programs p
, apps.fnd_concurrent_programs_tl pt
, apps.fnd_concurrent_requests f
WHERE TRUNC(((f.actual_completion_date-f.actual_start_date)/(1/24))*60) > NVL('&minutes',60)
and f.concurrent_program_id = p.concurrent_program_id
and f.program_application_id = p.application_id
and f.concurrent_program_id = pt.concurrent_program_id
and f.program_application_id = pt.application_id
AND pt.language = USERENV('Lang')
ORDER by f.actual_completion_date-f.actual_start_date desc
spool a_cm_long_reqs.log
/
--prompt 1 = REQ_ID to analyze
--@analyzereq.sql
spool off


kill a concurrent manager request in the apps by changig flags.sql
================================================================
/* killcmreq.sql
kill a concurrent manager request in the apps.
note: this only flips the phase and status flags,
it does NOT actually kill the o/s processes.
this processs does not issue a commit.
use the script cmreq.sql to view/verify the results.
*/
set verify off
set feedback on
accept reqid number default 0 prompt 'What is the concurrent request id <0> : '
update applsys.fnd_concurrent_requests
set phase_code = 'C',
status_code = 'X',
actual_completion_date = sysdate
where request_id = &reqid
and phase_code in ('P','R')
and status_code in ('W','R','A','Z','T')
and &reqid > 0;



list all scheduled requests.txt
===============================
SELECT cr.request_id,
DECODE (cp.user_concurrent_program_name,
'Report Set', 'Report Set:' || cr.description,
cp.user_concurrent_program_name
) NAME,
argument_text, cr.resubmit_interval,
NVL2 (cr.resubmit_interval,
'PERIODICALLY',
NVL2 (cr.release_class_id, 'ON SPECIFIC DAYS',
'ONCE')
) schedule_type,
DECODE (NVL2 (cr.resubmit_interval,
'PERIODICALLY',
NVL2 (cr.release_class_id, 'ON SPECIFIC DAYS',
'ONCE')
),
'PERIODICALLY', 'EVERY '
|| cr.resubmit_interval
|| ' '
|| cr.resubmit_interval_unit_code
|| ' FROM '
|| cr.resubmit_interval_type_code
|| ' OF PREV RUN',
'ONCE', 'AT :'
|| TO_CHAR (cr.requested_start_date, 'DD-MON-RR
HH24:MI'),
'EVERY: ' || fcr.class_info
) schedule,
fu.user_name, requested_start_date
FROM apps.fnd_concurrent_programs_tl cp,
apps.fnd_concurrent_requests cr,
apps.fnd_user fu,
apps.fnd_conc_release_classes fcr
WHERE cp.application_id =
cr.program_application_id
AND cp.concurrent_program_id =
cr.concurrent_program_id
AND cr.requested_by = fu.user_id
AND cr.phase_code = 'P'
AND cr.requested_start_date > SYSDATE
AND cp.LANGUAGE = 'US'
AND fcr.release_class_id(+) = cr.release_class_id
AND fcr.application_id(+) =
cr.release_class_app_id



logfile node name and op node name.txt
=======================================
SELECT LOGFILE_NAME, LOGFILE_NODE_NAME,OUTFILE_NAME , OUTFILE_NODE_NAME FROM FND_CONCURRENT_REQUESTS where REQUEST_ID=' ';

pending jobs in queue that shud be running.sql
===============================================
/* cmpending.sql
find pending jobs pending in a queue but should be running
*/
set lines 132
set pages 30
col program format a45 trunc
col phase_code format a1 trunc
col statustxt format a15 trunc
col parent format a8 trunc
col reqstarthide noprint
col minlate format 99999.90 head MinLate
set verify off
prompt Note: Minutes Late shown in decimal minutes.....
select a.requested_start_date reqstarthide,
to_char(a.requested_start_date,'mm/dd/yy hh24:mi') reqstart,
(sysdate-requested_start_date)*1440 minlate,
a.request_id "Req Id",
decode(a.parent_request_id,-1,NULL,a.parent_request_id) "Parent",
a.concurrent_program_id "Prg Id",
a.phase_code,
a.status_code || ' - ' ||l1.meaning statustxt,
c.concurrent_program_name||' - '|| c2.user_concurrent_program_name "program"
from APPLSYS.fnd_Concurrent_requests a,
APPLSYS.fnd_concurrent_programs_tl c2,
APPLSYS.fnd_concurrent_programs c,
applsys.fnd_lookup_values l1
where a.concurrent_program_id = c.concurrent_program_id
and a.program_application_id = c.application_id
and c2.concurrent_program_id = c.concurrent_program_id
and c2.language = 'US'
and c2.application_id = c.application_id
and a.actual_start_date is null
and a.status_code in ('A','H','I','M','P','Q','R')
and a.phase_code in ('P','I')
and sysdate - a.requested_start_date < 2
and a.requested_start_date < sysdate
and l1.lookup_type = 'CP_STATUS_CODE'
and l1.lookup_code = a.status_code
and l1.language = 'US'
and l1.enabled_flag = 'Y'
and (l1.start_date_active <= sysdate and l1.start_date_active is not null)
and (l1.end_date_active > sysdate or l1.end_date_active is null)
order by 1;


previous history of concurrent program.txt
========================================
REM To identify the concurrent program details for today
REM Enter concurrent program name in full or part
REM Remember to enter the concurrent program name
REM Author :- Rajiv Krishnan

set pages 100
set verify off
set echo off
set linesize 180
prompt Enter concurrent program name in full or part in correct case
prompt
accept prg_nm prompt 'PROGRAM_NAME->'
prompt
prompt Enter date of execution of the program
accept strt_dt prompt 'STARTING DATE OF EXECUTION->'
prompt
accept end_dt prompt 'ENDING DATE OF EXECUTION->'
prompt
column request_id format 99999999
column name format a30
break on NAME on USER_NM
--break on USER_NM skip 1
column ex_time format 999999.99
column user_nm format a10
column ARGUMENT_TEXT format 9999999;
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS'
/
select b.user_concurrent_program_name NAME,c.user_name USER_NM,a.request_id,(a.actual_completion_date-a.actual_start_date)*24*60 "EX_TIME",
a.actual_start_date "START_DT",a.actual_completion_date "COMPLETION_DT",a.ARGUMENT_TEXT
from apps.fnd_concurrent_requests a, apps.fnd_concurrent_programs_tl b, apps.fnd_user c
where a.concurrent_program_id=b.concurrent_program_id
and upper(b.user_concurrent_program_name) like upper('Purge%')
--and b.language='US'
and trunc(a.actual_start_date) between '01-JUL-2008' and nvl('01-JUL-2008','26-JUL-2008')
and a.requested_by=c.user_id
order by 1,2;


printer style information given for a particular request.txt
==============================================================
2. SELECT PRINTER_STYLE_NAME, SRW_DRIVER FROM FND_PRINTER_STYLES
WHERE PRINTER_STYLE_NAME = (SELECT PRINT_STYLE
FROM FND_CONCURRENT_REQUESTS where request_id='5996280');

reports all pending and running requests from FND_CONCURRENT_REQUESTS table with details of USER START TIME, ARGS and PROG NAME. Allows to limit thelist to a certain PROGRAM.txt
==========================================================
reports all pending and running requests from FND_CONCURRENT_REQUESTS table with details of USER START TIME, ARGS and PROG NAME. Allows to limit thelist to a certain PROGRAM

alter session set nls_date_format='DD-MON-RR HH24:MI';
set lines 132
set trims on
set echo off
set feed on
set pages 60
col request_id heading "Request ID"
col requested_start_date heading "Start Date"
col user_name format a10 trunc heading "APPS User"
col prg_name format a30 trunc heading "Program Name"
col args format a45 trunc heading "Agruments [first 45 chars]"
prompt Scheduled or running requests by date:
prompt
select /*+ ORDERED */
reqs.request_id
, reqs.requested_start_date requested_start_date
, reqs.phase_code
, reqs.status_code
, reqs.hold_flag
, reqs.cancel_or_hold
, usr.user_name
, prg.user_concurrent_program_name prg_name
, argument_text args
from apps.fnd_user usr
, apps.fnd_concurrent_requests reqs
, apps.fnd_concurrent_programs_tl prg
where reqs.phase_code IN ('P','R')
and reqs.concurrent_program_id = prg.concurrent_program_id
and prg.user_concurrent_program_name like '%&prog_like%'
and reqs.requested_by = usr.user_id
order by DECODE(reqs.phase_code,'R',1,2)
, reqs.requested_start_date
, usr.user_name
/


reports conc prog defn and group set it is assigned to .txt
=============================================================
set verify off
set feedback off
set serveroutput on size 100000
declare
cursor prog_cur IS
SELECT 'Program User Name: '|| FCPT.USER_CONCURRENT_PROGRAM_NAME prog_name
, 'Description: '|| FCPT.DESCRIPTION description
, 'Executable Name: '|| EXE.EXECUTABLE_NAME exe_name
, 'Executable File: '|| EXE.EXECUTION_FILE_NAME exe_file_name
, 'Execution Type: '|| decode(EXE.EXECUTION_METHOD_CODE,
'B', 'Request Set Stage Function',
'Q', 'SQL*Plus',
'H', 'Host',
'L', 'SQL*Loader',
'A', 'Spawned',
'I', 'PL/SQL Stored Procedure',
'P', 'Oracle Reports',
'S', 'Immediate',EXE.EXECUTION_METHOD_CODE) exe_method
, 'Style Req ?: '|| FND.REQUIRED_STYLE style_r
, 'Style Type: '|| FND.OUTPUT_PRINT_STYLE style_p
, 'Printer Name: '|| FND.PRINTER_NAME printer_name
, 'Min WIDTH: '|| FND.MINIMUM_WIDTH min_w
, 'Min LENGHT: '|| FND.MINIMUM_LENGTH min_l
, fnd.concurrent_program_id
FROM APPLSYS.FND_EXECUTABLES EXE
, APPLSYS.FND_CONCURRENT_PROGRAMS FND
, APPLSYS.FND_CONCURRENT_PROGRAMS_TL FCPT
WHERE EXE.EXECUTION_FILE_NAME = '&EXE_NAME'
AND EXE.EXECUTABLE_ID = FND.EXECUTABLE_ID
AND FND.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID
AND FND.APPLICATION_ID = FCPT.APPLICATION_ID
ORDER BY 1;
cursor group_cur (p_conc_prog_id NUMBER) IS
select FRG.REQUEST_GROUP_NAME r_g_name
FROM APPLSYS.FND_REQUEST_GROUPS FRG
, APPLSYS.FND_REQUEST_GROUP_UNITS FRGU
where FRGU.REQUEST_UNIT_ID = p_conc_prog_id
AND FRGU.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID;
begin
for prog_rec in prog_cur
LOOP
dbms_output.put_line(prog_rec.prog_name);
dbms_output.put_line(prog_rec.description);
dbms_output.put_line(prog_rec.exe_name);
dbms_output.put_line(prog_rec.exe_file_name);
dbms_output.put_line(prog_rec.exe_method);
dbms_output.put_line(prog_rec.style_r);
dbms_output.put_line(prog_rec.style_p);
dbms_output.put_line(prog_rec.printer_name);
dbms_output.put_line(prog_rec.min_w);
dbms_output.put_line(prog_rec.min_l);
dbms_output.put_line('---- Request Group Name ----');
for group_rec in group_cur(prog_rec.concurrent_program_id)
LOOP
dbms_output.put_line(group_rec.r_g_name);
END LOOP;
dbms_output.put_line('-----------------------------------------');
dbms_output.put_line('.');
END LOOP;
end;
/

reports concurrent program definations.txt
==============================================
set lines 132
ttitle off
btitle off
set pages 0
col new_line format a132
SELECT 'Program User Name: '|| FCPT.USER_CONCURRENT_PROGRAM_NAME new_line
, 'Description: '|| FCPT.DESCRIPTION new_line
, 'Executable Name: '|| EXE.EXECUTABLE_NAME new_line
, 'Executable File: '|| EXE.EXECUTION_FILE_NAME new_line
, 'Execution Type: '|| decode(EXE.EXECUTION_METHOD_CODE,
'B', 'Request Set Stage Function',
'Q', 'SQL*Plus',
'H', 'Host',
'L', 'SQL*Loader',
'A', 'Spawned',
'I', 'PL/SQL Stored Procedure',
'P', 'Oracle Reports',
'S', 'Immediate',EXE.EXECUTION_METHOD_CODE) new_line
, 'Style Req ?: '|| FND.REQUIRED_STYLE new_line
, 'Style Type: '|| FND.OUTPUT_PRINT_STYLE new_line
, 'Printer Name: '|| FND.PRINTER_NAME new_line
, 'Min WIDTH: '|| FND.MINIMUM_WIDTH new_line
, 'Min LENGTH: '|| FND.MINIMUM_LENGTH new_line
FROM APPLSYS.FND_EXECUTABLES EXE
, APPLSYS.FND_CONCURRENT_PROGRAMS FND
, APPLSYS.FND_CONCURRENT_PROGRAMS_TL FCPT
WHERE FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE '&NAME'
AND FCPT.APPLICATION_ID = FND.APPLICATION_ID
AND FCPT.CONCURRENT_PROGRAM_ID = FND.CONCURRENT_PROGRAM_ID
AND FND.EXECUTABLE_ID = EXE.EXECUTABLE_ID
/

show currently running requests on apps.txt
========================================

SET PAGESIZE 9999;
SET VERIFY off;
SET FEEDBACK off;
SET LINESIZE 132;
--
COLUMN concreq HEADING 'Conc Req ID' FORMAT A12;
COLUMN clproc HEADING 'Client|Process' FORMAT A11;
COLUMN opid HEADING 'ORACLE PID' FORMAT A10;
COLUMN reqph HEADING 'Req Phase' FORMAT A10;
COLUMN reqst HEADING 'Req Status' FORMAT A10;
COLUMN dbuser HEADING 'DB User' FORMAT A10;
COLUMN svrproc HEADING 'Srvr|Process' FORMAT A10;
COLUMN sid HEADING 'SID' FORMAT 99999;
COLUMN serial# HEADING 'Serial#' FORMAT 99999;
SELECT SUBSTR(LTRIM(req.request_id),1,15) concreq,
SUBSTR(proc.os_process_id,1,15) clproc,
SUBSTR(LTRIM(proc.oracle_process_id),1,15) opid,
SUBSTR(look.meaning,1,10) reqph,
SUBSTR(look1.meaning,1,10) reqst,
SUBSTR(vsess.username,1,10) dbuser,
SUBSTR(vproc.spid,1,10) svrproc,
vsess.sid sid,
vsess.serial# serial#
FROM fnd_concurrent_requests req,
fnd_concurrent_processes proc,
fnd_lookups look,
fnd_lookups look1,
v$process vproc,
v$session vsess
WHERE req.controlling_manager = proc.concurrent_process_id(+)
AND req.status_code = look.lookup_code
AND look.lookup_type = 'CP_STATUS_CODE'
AND req.phase_code = look1.lookup_code
AND look1.lookup_type = 'CP_PHASE_CODE'
AND look1.meaning = 'Running'
AND proc.oracle_process_id = vproc.pid(+)
AND vproc.addr = vsess.paddr(+);


Shows current statements for active sessions.TXT
==================================================

column pu format a8 heading 'O/S|Login|ID'
column su format a8 heading 'Oracle|User ID'
column stat format a8 heading 'Session|Status'
column ssid format 999999 heading 'Oracle|Session|ID'
column sser format 999999 heading 'Oracle|Serial|No'
column spid format 99999999 heading 'O/S|Process|ID'
column txt format a2000 heading 'Current Statement' wrapped

set linesize 1000
set pagesize 32000
set trimspool on

select p.username pu
, s.username su
, s.status stat
, s.sid ssid
, s.serial# sser
, substr(p.spid,1,8) spid
, substr(sa.sql_text,1,2000) txt
from v$process p
, v$session s
, v$sqlarea sa
where p.addr = s.paddr
and s.username is not null
and s.sql_address = sa.address(+)
and s.sql_hash_value = sa.hash_value(+)
and s.status = 'ACTIVE'
order by 1,2,7
/

column pu clear
column su clear
column stat clear
column ssid clear
column sser clear
column spid clear
column txt clear


sid from os proces id.txt
=========================
/* osproc.sql
find the Oracle session info for a given OS process id
*/
col machine format a15 trunc
col program format a25 trunc
col LastCallET format a11
col status format a1 trunc
col module format a12 trunc
set verify off
accept trgtproc char default 0 prompt 'What is the OS process id : '
select s.sid,s.status,
floor(last_call_et/3600)||':'||
floor(mod(last_call_et,3600)/60)||':'||
mod(mod(last_call_et,3600),60) "LastCallET",
s.machine,s.module,s.process,s.sql_hash_value
from v$session s, v$process p
where s.paddr = p.addr
and p.spid = '&trgtproc';


SId,serial# information for one running request.txt
===================================================
SQL> column process heading "FNDLIBR PID"
SELECT a.request_id, d.sid,d.event, d.serial# ,d.osuser,d.process
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
gv$process c,
gv$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = 7178574;
AND a.phase_code = 'R';

status and completion of any conc request.txt
=============================================
SELECT NLS_CODESET, OUTPUT_FILE_TYPE filetype, OUTFILE_NODE_NAME node,
OUTFILE_NAME, COMPLETION_TEXT
FROM FND_CONCURRENT_REQUESTS where request_id='&REQUEST_ID';


to find abandoned UNIX PID for a concurrent manager program.txt
===============================================================

COL c1 FORMAT 99999999 HEADING "Oracle|Process|ID #"
COL c2 FORMAT 99999999 HEADING "PPID"
COL c3 FORMAT 99999999 HEADING "Process|ID #"
COL c4 FORMAT 99999999 HEADING "Concurrent|ID #"
COL c5 FORMAT A8 HEADING "User Name"
COL c6 FORMAT A15 HEADING "Time|Started"
COL c7 FORMAT A7 HEADING "Time|Elapsed"
COL c8 FORMAT A10 HEADING "Short Name"

SPOOL UT_VCMGR.log

SELECT DISTINCT
fvp.pid c1
, fvp.spid c2
, vp.spid c3
, fcr.request_id c4
, SUBSTR(fu.user_name,0,8) c5
, SUBSTR(TO_CHAR(actual_start_date,'DD-MON-YY HH24:MI'),0,15) c6
, SUBSTR(TO_CHAR(TO_DATE(actual_start_date,'DD-MON-YY')
|| (SYSDATE - actual_start_date),'HH24:MI'),0,7) c7
, SUBSTR(concurrent_program_name, 0, 15) c8
FROM fnd_concurrent_requests fcr
, fnd_concurrent_programs fcp
, fnd_logins fl1
, fnd_logins fl2
, fnd_user fu
, fnd_v$process fvp
, v$process vp
WHERE fl1.login_id = fcr.conc_login_id
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fl1.submitted_login_id = fl2.login_id
AND fu.user_id = fl1.user_id
AND fcr.phase_code = 'R'
AND fvp.pid (+) = fl2.pid
AND vp.pid (+) = fl2.pid;

SPOOL OFF

Trace File For a Concurrent Request id.txt
============================================
column traceid format a8
column tracename format a80
column user_concurrent_program_name format a40
column execname format a15
column enable_trace format a12
set lines 80
set pages 22
set head off
select
'Request id: '||request_id ,
'Trace id: '||oracle_Process_id,
'Trace Flag: '||req.enable_trace,
'Trace Name: '||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc',
'Prog. Name: '||prog.user_concurrent_program_name,
'File Name: '||execname.execution_file_name|| execname.subroutine_name ,
'Status : '||decode(phase_code,'R','Running') ||'-'||decode(status_code,'R','Normal'),
'SID Serial: '||ses.sid||','|| ses.serial#,
'Module : '||ses.module
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog, fnd_executables execname
where req.request_id = &request
and req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name='user_dump_dest'
and dbnm.name='db_name'
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id
and prog.executable_id=execname.executable_id
/

WHEN REQUETS IN RUNNING + TERMINATING.txt
==========================================If the request remains in a phase of RUNNING and a status of TERMINATING after allocating more processes to the manager, then shutdown the concurrent managers, kill any processes from the operating system that won't terminate, and execute the following sqlplus statement as the APPLSYS user to reset the managers in the FND_CONCURRENT_REQUESTS table:
update fnd_concurrent_requests
set status_code='X', phase_code='C'
where status_code='T';


Which manager ran request
=========================
select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a,
fnd_concurrent_queues_vl b, fnd_concurrent_requests c
where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID
and a.CONCURRENT_PROCESS_ID = c.controlling_manager
and c.request_id = *****;