Work Flow Mailer Send Mail from the Cloned Instance

Do you find that ,

YOur Work Flow mailer is trigerring Mail often when you clone your Instance and you are unable to test the New stuff using work Flow Mailer


Here is the solution for the Work flow mailer to stop sending older mails in the Test Instance

UPDATE WF_NOTIFICATIONS

SET STATUS = 'CLOSED'

where status ='OPEN';

UPDATE WF_NOTIFICATIONS

SET MAIL_STATUS = 'SENT'

where status ='OPEN';

commit; 

Simple , but very Effective steps to Contrl your work flow mailer , sending old mails


Check  this Steps too:

Applicatioin Manager -- > Application Dashboard ->


Application System-- > Dev--> service Components --> Component Details

Set override Address : Dev: Work Flow Notification Mailer

Enter the Over Ride Address : *******. Mail .Com


Update the scripts:

update fnd_svc_comp_param_vals fscpv
set fscpv.PARAMETER_VALUE = '<override email address>'
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');

If this is Entered he/She will receive all the notification mails which has beed triggred in the DEv or UAT

Step 1Login to "Workflow Administrator Web Applications"


Step 2
Ensure that Notification Mailer is running, and then click on icon as below


Step 3
Click on "View Details"




Step 4.
Click on "Set Override Address"




Step 5.
Finally you can change the email address here. Please read the instructions in red carefully.