Start notification mailer in R12

To start notification mailer, we need to execute the following.

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

  • April 26, 2016 | 17 views