ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4E6589A63CEC49A2BECB0A0DB7317CD0Y 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 US WF Service Components 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. Enginatics &parameter_columns &parameter_order &parameter_table 1=1 1 10 1=1 fscttl.display_name=:component_type LOV custom Y select fscttl.display_name value, null description from fnd_svc_comp_types_tl fscttl where fscttl.language=userenv('lang') order by fscttl.display_name US Component Type 2 20 1=1 initcap(replace(fsc.component_status,'_',' '))=:status LOV custom Y select distinct initcap(replace(fsc.component_status,'_',' ')) value, null description from fnd_svc_components fsc order by 1 US Status 3 30 1=1 fsc.component_status<>'RUNNING' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Not Running only 4 40 &parameter_columns fscpvv.parameter_display_name parameter, decode(fscpvv.encrypted_flag,'Y','*****',fscpvv.parameter_value) parameter_value, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Parameters 5 &parameter_order , fscpvv.parameter_display_name US Show Parameters 6 &parameter_table , fnd_svc_comp_param_vals_v fscpvv US Show Parameters 7 1=1 fsc.component_id=fscpvv.component_id(+) US Show Parameters