Monday, September 9, 2013
Steps to start/stop Workflow Notification Mailer (fnd_svc_component)
1. Check
workflow mailer service current status
SELECT running_processes
SELECT running_processes
FROM fnd_concurrent_queues
WHERE concurrent_queue_name ='WFMLRSVC';
Note : Number of running processes > 0
2. Find current mailer status
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
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
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;
/
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
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.
2 Responses to “Steps to start/stop Workflow Notification Mailer (fnd_svc_component)”
December 29, 2018 at 9:50 PM
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
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