WF Service Components

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Workflow service components, such as the notification mailer, agent listeners and web services agents, with their status, startup mode and the concurrent manager container running them.

Show Parameters lists the component's configuration parameters, for example the mailer's SMTP and IMAP servers, reply-to and test address. Encrypted values such as passwords are masked.

Schedule the r ...  Workflow service components, such as the notification mailer, agent listeners and web services agents, with their status, startup mode and the concurrent manager container running them.

Show Parameters lists the component's configuration parameters, for example the mailer's SMTP and IMAP servers, reply-to and test address. Encrypted values such as passwords are masked.

Schedule the report with Not Running only to get an email when the notification mailer or an agent listener stops.   more 
select
fscttl.display_name component_type,
fsc.component_name,
initcap(replace(fsc.component_status,'_',' ')) status,
fsc.component_status_info status_info,
initcap(fsc.startup_mode) startup_mode,
fcqv.user_concurrent_queue_name container,
fcqv.running_processes container_processes,
fsc.inbound_agent_name,
fsc.outbound_agent_name,
fsc.correlation_id,
fsc.max_idle_time,
&parameter_columns
xxen_util.user_name(fsc.last_updated_by) last_updated_by,
xxen_util.client_time(fsc.last_update_date) last_update_date
from
fnd_svc_components fsc,
fnd_svc_comp_types_tl fscttl,
fnd_concurrent_queues_vl fcqv
&parameter_table
where
1=1 and
fsc.component_type=fscttl.component_type(+) and
fscttl.language(+)=userenv('lang') and
fsc.concurrent_queue_id=fcqv.concurrent_queue_id(+)
order by
component_type,
fsc.component_name
&parameter_order
Parameter NameSQL textValidation
Component Type
fscttl.display_name=:component_type
LOV
Status
initcap(replace(fsc.component_status,'_',' '))=:status
LOV
Not Running only
fsc.component_status<>'RUNNING'
LOV
Show Parameters
fscpvv.parameter_display_name parameter,
decode(fscpvv.encrypted_flag,'Y','*****',fscpvv.parameter_value) parameter_value,
LOV
Download
Related Blitz Reports
CAC Cost vs. Planning Item Controls CAC Calculate ICP PII Item Costs by Where Used CAC Item vs. Component Include in Rollup Controls CAC Manufacturing Variance ECC Enterprise Asset Management, Work Order Assets (Maintenance) ONT Sales Order Acknowledgement EAM PM Schedule Upload ECC Discrete Manufacturing, Components CST Supply Chain Indented Bills of Material Cost
Blitz Report™