My Oracle Support Banner

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

Last updated on MARCH 15, 2021

Applies to:

Oracle Workflow - 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 messages 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 processing. 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.