Alerts along with Other Notifications Are Getting Piled Up In The Out Queue And Not Sending Emails
(Doc ID 733539.1)
Last updated on SEPTEMBER 07, 2023
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 |