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 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.


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

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

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



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.


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.