How do I start and stop a workflow in Oracle Apps?

Steps to start/stop Workflow Notification Mailer (fnd_svc_component)

1. Check workflow mailer service current status. SELECT running_processes. FROM fnd_concurrent_queues.
2. Find current mailer status. SELECT component_status. FROM fnd_svc_components.
3. Stop notification mailer. DECLARE. p_retcode NUMBER;
4. Start notification mailer.

What is Workflow Deferred Agent Listener?

“Workflow Deferred Agent Listener” must be running to clear the events from this queue. Several EBS modules have subscribers to various Workflow BES events with a phase >100 which means that the subscribers will be deferred for the agent listeners to process later.

How do I restart workflow services in Oracle Apps R12?

Select ‘Start’ Action and click ‘Go’ button….Below are the steps we to restart the agent listeners :

1. Login with Workflow Administrator responsibility.
2. Select ‘Workflow Manager’ link.
3. Click ‘Agent Listener’ icon.
4. Please make sure all workflow agent listeners are up.
5. Restart the below mentioned workflow agent listeners.

How do I start a workflow mailer?

How to start the Workflow Mailer Service Using Oracle Application Manager (OAM)

1. Login to OAM.
2. Navigate to Workflow.
3. Click on Service Components you will find a new page with item name “Workflow Notification Mailer” and Container “Workflow Mailer Service”
4. Under column container click on Workflow Agent Listener Service.

How do I stop a workflow agent listener service?

Select ‘Start’ Action and click ‘Go’ button. Select ‘Workflow Java Deferred Agent Listener’ Select ‘Stop’ Action and click ‘Go’ button.

How do I start workflow notification mailer from front end?

How to start the Workflow Mailer Service Using Oracle Application Manager (OAM)

1. Login to OAM.
2. Navigate to Workflow.
3. Under column container click on Workflow Agent Listener Service.
4. From drop down list at the end of the line , choose start then click on Go button.

How do I restart workflow agent listener service?

How do I know if my workflow mailer is running?

Check if the Workflow Mailer notification has been sent or not

1. select mail_status, status from wf_notifications where notification_id= :notification_id.
2. If mail_status is MAIL, it means the email delivery is pending for workflow mailer to send the email notification.