Oracle Applications HOWTO: programmatically start notification mailer

Go to Michael Dvorkin's user page

Prerequisites
E-Business Suite 11.5.9, 11.5.10

Steps to start/stop notification mailer
1. Check workflow mailer service current status

sqlplus apps/ 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

sqlplus apps/ 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

2. Stop notification mailer

sqlplus apps/ declare p_retcode number; p_errbuf varchar2(100); m_mailerid fnd_svc_components.component_id%TYPE; begin -- Find mailer Id       - select component_id into m_mailerid from fnd_svc_components where component_name = 'Workflow Notification Mailer'; --       -- Stop Mailer --       fnd_svc_component.stop_component(m_mailerid, p_retcode, p_errbuf); commit; end; /

3. Start notification mailer

sqlplus apps/ declare p_retcode number; p_errbuf varchar2(100); m_mailerid fnd_svc_components.component_id%TYPE; begin -- Find mailer Id       - select component_id into m_mailerid from fnd_svc_components where component_name = 'Workflow Notification Mailer'; --       -- Start Mailer --       fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf); commit; end; /

Known Issues
Go to Michael Dvorkin's user page