Oracle Apps Scripts

Runing Concurrent Requests

Set Line 123
Set Pages 1000
Set Head On


Column user_name Format A12 Heading "User Name"
Column start Format A20 Heading "Start Date Time"
Column status_code Format A12 Heading "Status"
Column queue_name Format A25 Heading "Manager - Node"
Column user_concurrent_program_name Format A37 Heading "Program Name"
Column Request_id Format 99999999 Heading "Request ID"


select
c.user_name,
a.Request_id,
to_char(a.actual_start_date,'DD-MON-YYYY HH24:MI:SS') "Start",
decode(a.status_code,
'A','Waiting',
'B', 'Resuming',
'C', 'Normal',
'D', 'Cancelled',
'E', 'Error',
'G', 'Warning',
'H', 'On Hold',
'I', 'Normal',
'M', 'No Manager',
'P', 'Scheduled',
'Q', 'Standby',
'R', 'Normal',
'S', 'Suspended',
'T', 'Terminating',
'U', 'Disabled',
'W', 'Paused',
'X', 'Terminated',
'Z', 'Waiting') status_code,
b.user_concurrent_queue_name||' - '||b.target_node "queue_name",
a.user_concurrent_program_name
from fnd_concurrent_worker_requests a,
fnd_concurrent_queues_vl b,
fnd_user c
where a.concurrent_queue_id=b.concurrent_queue_id
and a.phase_code='R'
and a.requested_by=c.user_id
Order by 5;

Managers that are currently running a request

Set Pages 1000
Set head on

Column Manager Format A20
Column Request Format 99999999
Column Program Format A15
Column User_Name Format A15
Column Started Format A15

prompt Managers that are currently running a request;
prompt ;

Select Concurrent_Queue_Name Manager,
Request_Id Request, User_name,
Concurrent_Program_Name Program, Run_Alone_Flag,
To_Char(Actual_Start_Date, 'DD-MON-YY HH24:MI') Started
from Fnd_Concurrent_Queues Fcq, Fnd_Concurrent_Requests Fcr,
Fnd_Concurrent_Programs Fcp, Fnd_User Fu, Fnd_Concurrent_Processes Fpro
where
Phase_Code = 'R' And
Fcr.Controlling_Manager = Concurrent_Process_Id And
(Fcq.Concurrent_Queue_Id = Fpro.Concurrent_Queue_Id And
Fcq.Application_Id = Fpro.Queue_Application_Id ) And
(Fcr.Concurrent_Program_Id = Fcp.Concurrent_Program_Id And
Fcr.Program_Application_Id = Fcp.Application_Id ) And
Fcr.Requested_By = User_Id
;