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 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***


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. 


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