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)
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