How To Move Notifications From Exception Queue To Normal Queue?
Last updated on OCTOBER 04, 2016
Applies to:Oracle Workflow Cartridge - Version 188.8.131.52 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
Million Knowledge Articles and hundreds of Community platforms