Workflow Mailer Is Running, But A User Receives No Notifications
Last updated on AUGUST 31, 2017
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.
On 12.1.3 version, Workflow Mailer
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');
SQL> select count(*) from applsys.wf_notifications where mail_status = 'MAIL' and STATUS='OPEN';
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?
Expect the notifications to be sent.
The issue has the following business impact:
Due to this issue, 43 notifications are not sent.
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