Workflow Mailer Is Running, But A User Receives No Notifications (Doc ID 2303035.1)

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.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms