FND Concurrent Managers

➜ Back to Library
Description
Categories: Application, DBA, Enginatics
Concurrent managers' setup and current status, e.g. processes and requests running, pending etc.
Shows the same information as Concurrent->Manager->Administer and Concurrent->Manager->Define 
select
fcqv.user_concurrent_queue_name manager,
fcqv.concurrent_queue_name short_name,
xxen_util.meaning(fcqv.enabled_flag,'YES_NO',0) enabled_flag,
fav.application_name,
fcsv.service_name type,
fcqv.target_node,
fcqv.running_processes actual,
fcqv.target_processes target,
fcwr0.running,
fcwr0.pending,
fcwr0.on_hold,
fcwr0.scheduled,
xxen_util.meaning(fcqv.control_code,'CP_CONTROL_CODE',0) status,
&columns
fcqv.cache_size,
fcqv.sleep_seconds,
fcqv.node_name primary_node,
fcqv.node_name2 secondary_node,
fcqv.concurrent_queue_id
from
fnd_concurrent_queues_vl fcqv,
fnd_application_vl fav,
fnd_cp_services_vl fcsv,
(
select
fcwr.concurrent_queue_id,
fcwr.queue_application_id,
sum(case when fcwr.phase_code='R' then 1 end) running,
sum(case when fcwr.phase_code='P' and fcwr.hold_flag<>'Y' and fcwr.requested_start_date<=sysdate then 1 end) pending,
sum(case when fcwr.hold_flag='Y' then 1 end) on_hold,
sum(case when fcwr.phase_code='P' and fcwr.hold_flag<>'Y' and fcwr.requested_start_date>sysdate then 1 end) scheduled
from
fnd_concurrent_worker_requests fcwr
where
fcwr.phase_code in ('R','P')
group by
fcwr.concurrent_queue_id,
fcwr.queue_application_id
) fcwr0,
(
select
fcwr.queue_application_id,
fcwr.concurrent_queue_id,
row_number() over (partition by fcwr.queue_application_id,fcwr.concurrent_queue_id order by fcwr.priority,fcwr.priority_request_id,fcwr.request_id) position,
fcwr.request_id,
fnd_amp_private.get_phase (fcwr.phase_code,fcwr.status_code,fcwr.hold_flag,fcwr.enabled_flag,fcwr.requested_start_date,fcwr.request_id) phase,
fnd_amp_private.get_status (fcwr.phase_code,fcwr.status_code,fcwr.hold_flag,fcwr.enabled_flag,fcwr.requested_start_date,fcwr.request_id) status,
fcwr.request_description program,
xxen_util.user_name(fcwr.requested_by) requestor,
fcwr.argument_text request_parameters
from
fnd_concurrent_worker_requests fcwr
where
'&show_requests'='Y' and
(fcwr.phase_code='P' or fcwr.phase_code='R') and
fcwr.hold_flag!='Y' and
fcwr.requested_start_date<=sysdate
) fcwr,
(select fcqc.* from fnd_concurrent_queue_content fcqc where '&show_specialization_rules'='Y') fcqc,
fnd_concurrent_programs_vl fcpv,
(select fcpr.* from fnd_concurrent_processes fcpr where '&show_processes'='Y') fcpr,
(
select distinct
fcr.controlling_manager,
decode(fcr.status_code,'R','A','T','A','X','K') process_status_code,
max(fcr.request_id) over (partition by fcr.controlling_manager,decode(fcr.status_code,'R','A','T','A','X','K')) request_id,
max(fcr.os_process_id) keep (dense_rank last order by fcr.request_id) over (partition by fcr.controlling_manager,decode(fcr.status_code,'R','A','T','A','X','K')) os_process_id
from
fnd_concurrent_requests fcr
where
'&show_processes'='Y' and
fcr.status_code in ('R','T')
) fcr
where
1=1 and
fcqv.application_id=fav.application_id and
fcqv.manager_type=fcsv.service_id(+) and
fcqv.application_id=fcwr0.queue_application_id(+) and
fcqv.concurrent_queue_id=fcwr0.concurrent_queue_id(+) and
fcqv.application_id=fcwr.queue_application_id(+) and
fcqv.concurrent_queue_id=fcwr.concurrent_queue_id(+) and
fcqv.application_id=fcqc.queue_application_id(+) and
fcqv.concurrent_queue_id=fcqc.concurrent_queue_id(+) and
decode(fcqc.type_code,'P',fcqc.type_application_id)=fcpv.application_id(+) and
decode(fcqc.type_code,'P',fcqc.type_id)=fcpv.concurrent_program_id(+) and
fcqv.application_id=fcpr.queue_application_id(+) and
fcqv.concurrent_queue_id=fcpr.concurrent_queue_id(+) and
fcpr.concurrent_process_id=fcr.controlling_manager(+) and
fcpr.process_status_code=fcr.process_status_code(+)
order by
fcqv.enabled_flag desc,
decode (fcqv.application_id,0,decode(fcqv.concurrent_queue_id,1,1,4,2)),
sign(fcqv.max_processes) desc,
fcqv.concurrent_queue_name,
fcqv.application_id,
&order_by
1
Parameter Name SQL text Validation
Show Requests 
Y
 LOV
Show Processes 
Y
 LOV
Show Specialization Rules 
Y
 LOV
Show Requests 
fcwr.position,
Show Requests 
fcwr.position,
fcwr.request_id,
fcwr.phase,
fcwr.status,
fcwr.program,
fcwr.requestor,
fcwr.request_parameters,
Show Processes 
decode (fcpr.process_status_code,'R',1,'T',1,'A',2,'P',2,'Z',3,'K',3,'S',3,'X',3,4),
fcpr.last_update_date desc,
Show Processes 
xxen_util.meaning(fcpr.process_status_code,'CP_PROCESS_STATUS_CODE',0) process_status_code,
fcpr.concurrent_process_id concurrent_id,
fcpr.oracle_process_id oracle_id,
fcpr.os_process_id os_id,
fcr.request_id,
fcr.os_process_id request_os_id,
fcpr.process_start_date,
Show Specialization Rules 
xxen_util.meaning(fcqc.include_flag,'INCLUDE_EXCLUDE',0) include_exclude,
xxen_util.meaning(fcqc.type_code,'CP_SPECIAL_RULES',0) type,
(select fav.application_name from fnd_application_vl fav where fcqc.type_application_id=fav.application_id) type_application,
fcpv.user_concurrent_program_name name,
Active Requests Only 
fcwr.request_id is not null
 LOV
Active Processes Only 
fcpr.process_status_code not in ('K','S')
 LOV
Manager Name 
fcqv.user_concurrent_queue_name=:manager_name
 LOV
Download
Related Blitz Reports
COPY OF: FND Concurrent Managers
FND Concurrent Requests
FND Concurrent Request Conflicts
FND Attached Documents
FND Concurrent Programs and Executables
XDO Publisher Datasources
FND Concurrent Requests Summary
PON Solicitation data template
FND Access Control
Blitz Report In Action