Disabling the workflow notification mailer in a clone
Posted on September 18, 2014 by Leith Suheimat
When cloning a Production EBS environment, these are the steps I follow to disable the Workflow Notification Mailer in the cloned instance before starting up the application:
update fnd_user set email_address = null
where email_address is not null;
update per_all_people_f set email_address = null
where email_address is not null;
update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';
Finally, although it is not strictly required, I run this script from MOS 1412224.1 to ensure the Notification Mailer is totally disabled:
sqlplus apps/<passwd> @$FND_TOP/sql/wfmlpcln.sql
The Notification Mailer can be configured later if required.
https://leithsuheimat.wordpress.com/2014/09/18/disabling-the-workflow-notification-mailer-in-a-clone/
Posted on September 18, 2014 by Leith Suheimat
When cloning a Production EBS environment, these are the steps I follow to disable the Workflow Notification Mailer in the cloned instance before starting up the application:
update fnd_user set email_address = null
where email_address is not null;
update per_all_people_f set email_address = null
where email_address is not null;
update WF_NOTIFICATIONS set mail_status = 'SENT' where mail_status = 'MAIL';
Finally, although it is not strictly required, I run this script from MOS 1412224.1 to ensure the Notification Mailer is totally disabled:
sqlplus apps/<passwd> @$FND_TOP/sql/wfmlpcln.sql
The Notification Mailer can be configured later if required.
https://leithsuheimat.wordpress.com/2014/09/18/disabling-the-workflow-notification-mailer-in-a-clone/
No comments:
Post a Comment