This discussion is archived
2 Replies Latest reply: Nov 27, 2012 10:00 PM by stopuz RSS

How to purge Workflow queue after R12 upgrade before starting WF Mailer?

stopuz Newbie
Currently Being Moderated
Hi,

We are about to upgrade to R12.1.3 from R11.5.9.

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?

Thanks,
Sinan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points