FND Concurrent Managers

➜ Back to Library
Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Manager, Short Name, Enabled Flag, Application Name, Type, Target Node, Actual, Target, Running, Pending ...
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 Specialization Rules 
Y
 LOV
Show Processes 
Y
 LOV
Show Requests 
Y
 LOV
Manager Name 
fcqv.user_concurrent_queue_name=:manager_name
 LOV
Active Processes only 
fcpr.process_status_code not in ('K','S')
 LOV
Active Requests only 
fcwr.request_id is not null
 LOV
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,
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 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 Requests 
fcwr.position,
fcwr.request_id,
fcwr.phase,
fcwr.status,
fcwr.program,
fcwr.requestor,
fcwr.request_parameters,
Show Requests 
fcwr.position,
Download
 
Related Blitz Reports
FND Concurrent Requests 11i FND Concurrent Requests EIS Execution History ECC Admin - Concurrent Programs FND Concurrent Requests Summary FND Concurrent Request Conflicts Concurrent Requests Bucketed FND Attached Documents XDO Publisher Data Definitions
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: