2 Replies Latest reply: Nov 28, 2012 12:00 AM by stopuz RSS

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

    stopuz
      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