My Oracle Support Banner

Alerts along with Other Notifications Are Getting Piled Up In The Out Queue And Not Sending Emails (Doc ID 733539.1)

Last updated on FEBRUARY 01, 2022

Applies to:

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


Symptoms

Using the Oracle Applications Release 11.5.10.2 with ATG.RUP5 patchset applied:

Oracle alerts that are defined to send notifications are not sending emails. Instead they are getting
piled up in applsys.aq$wf_notification_out table.

Restarting the workflow service will process the messages for a time but eventually the problem re-occurs.


.

Changes

NOTE: As of ATG RUP5 this script will halt if there are Oracle Alerts un-processed messages on the WF_NOTIFICATION_OUT_N1 queue, these messages cannot be recovered so they must be processed before the script will continue.

Cause

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
Symptoms
Changes
Cause
Solution

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