Steps to start/stop Workflow Notification Mailer
- Check workflow mailer service current status
SQL> select running_processes from fnd_concurrent_queues
where concurrent_queue_name = ‘WFMLRSVC’;
RUNNING_PROCESSES
—————–
1
Number of running processes should be greater than 0
- Find current mailer status
SQL> select component_status
from fnd_svc_components
where component_id =
(select component_id
from fnd_svc_components
where component_name = ‘Workflow Notification Mailer’);
COMPONENT_STATUS
——————————
DEACTIVATED_USER
Possible values are :
RUNNING STARTING,
STOPPED_ERROR,
DEACTIVATED_USER
DEACTIVATED_SYSTEM.
- Stop Workflow mailer
declare
p_retcode number;
p_errbuf varchar2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
begin
select component_id
into m_mailerid
from fnd_svc_components
where component_name = ‘Workflow Notification Mailer’;
fnd_svc_component.stop_component(m_mailerid, p_retcode, p_errbuf);
commit;
end;
/
- Start the Notification Mailer
declare
p_retcode number;
p_errbuf varchar2(100);
m_mailerid fnd_svc_components.component_id%TYPE;
begin
select component_id
into m_mailerid
from fnd_svc_components
where component_name = ‘Workflow Notification Mailer’;
fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);
commit;
end;
/