EBS: Workflow Mailer Status

EBS: Workflow Mailer Status

1. Check workflow mailer service current status

select running_processes from apps.fnd_concurrent_queues where concurrent_queue_name = 'WFMLRSVC';

Number of running processes should be greater than 0

2. Find current mailer status

SELECT component_name as Component, component_status as Status FROM fnd_svc_components where component_name = 'Workflow Notification Mailer';
or
select component_status from apps.fnd_svc_components where component_id = (select component_id from apps.fnd_svc_components where component_name = 'Workflow Notification Mailer');

Possible values:

RUNNING
STARTING
STOPPED_ERROR
DEACTIVATED_USER
DEACTIVATED_SYSTEM