How To Move Notifications From Exception Queue To Normal Queue? (Doc ID 472204.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Workflow Cartridge - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 7-Jul-2013***

Goal

There are cases where messges could be retried and after some retries these messages could expire and move to exception queue. Say for instance a notification supposed to be sent out is stuck in status=OPEN, mail_status=MAIL and when one checks the $FND_TOP/sql/wfmlrdbg.sql output for this notification id it shows the WF_NOTIFICATION_OUT queue status as:

Message State = EXPIRED, Exception Queue = AQ$_WF_NOTIFICATION_OUT_E ,Retry Count = 5

In these cases how do we move all EXPIRED messages from the exception queue to normal queue and do subsequent processesing. 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms