DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 26, 2016

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;
 /

1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.