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
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
No comments:
Post a Comment