Monday, September 9, 2013

Steps to start/stop Workflow Notification Mailer (fnd_svc_component)















1. Check workflow mailer service current status

SELECT running_processes
FROM fnd_concurrent_queues
WHERE concurrent_queue_name ='WFMLRSVC';

Note : Number of running processes > 0

2. Find current mailer status

SELECT component_status
  FROM fnd_svc_components
 WHERE component_id =(SELECT component_id
                        FROM fnd_svc_components
                       WHERE component_name ='Workflow Notification Mailer');

Possible statuses are :
    RUNNING
   STARTING
   STOPPED_ERROR
   DEACTIVATED_USER
   DEACTIVATED_SYSTEM


3. Stop 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.stop_component (m_mailerid,
                                     p_retcode,
                                     p_errbuf
                                    );
COMMIT;
END;
/

4. Start 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;
/

2 Responses to “Steps to start/stop Workflow Notification Mailer (fnd_svc_component)”

Unknown said...
December 29, 2018 at 9:50 PM

Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com


m.ali said...
May 7, 2021 at 4:41 AM

I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page! High-Ticket Business Model


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.