As part of the testing, I configured and started the Workflow Mailer in the new system. As soon as I did that, the system started sending a ton of notifications regarding past Requisition approvals apparently queued in the system. WF Mailer has been down since I did the last upgrade test.
We plan to approve all requisitions before the cutover in the old system, so there should be no email notifications pending. Is there a way of updating msg_state of those notifications in the wf_notification_out table with a value of "READY", so we can make sure that we will have a clean system and users will not receive any notifications regarding the past requisition approvals?
Note: 847889.1 - Stop Workflow Notification Emails During Clone Note: 828812.1 - How To Stop Old Outbound Workflow Notification Email Messages During Clone Activity Note: 603003.1 - How To Remove Workflow Data On A Test Or Cloned Instance Note: 372933.1 - How to purge e-mail notifications from the workflow queue so the e-mail is not sent Note: 736508.1 - How to Cancel Email Notifications for Particular Workflow Type