Steps to start/stop Workflow Notification Mailer--backend

 

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;

/