Workflow Mailer Is Running, But A User Receives No Notifications
(Doc ID 2303035.1)
Last updated on MAY 19, 2024
Applies to:
Oracle Workflow - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
On 12.1.3 version, Workflow Mailer
ACTUAL BEHAVIOR
Workflow mailer is running, but the following number of ITEMS are not sent:
SQL> select count(*) from applsys.wf_notifications where mail_status = 'MAIL' and STATUS NOT IN ('CLOSED','CANCELED');
COUNT(*)
----------
43
SQL> select count(*) from applsys.wf_notifications where mail_status = 'MAIL' and STATUS='OPEN';
COUNT(*)
----------
43
Understood that there is no notification for the mailer to process, but the question still remains, why there are 43 unsent notifications for a user?
EXPECTED BEHAVIOR
Expect the notifications to be sent.
The issue has the following business impact:
Due to this issue, 43 notifications are not sent.
Changes
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 |