My Oracle Support Banner

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

Last updated on AUGUST 23, 2023

Applies to:

Oracle Workflow - Version to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


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. 


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

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