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;

/

Recent Posts

Start typing and press Enter to search