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>
 p_retcode number;
 p_errbuf varchar2(100);
 m_mailerid fnd_svc_components.component_id%TYPE;
 -- 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);

1 comment:

Sridevi K said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.