Issue with Alert Framework is not Sending Consolidated Emails (Doc ID 2726049.1)

Last updated on NOVEMBER 04, 2020

Applies to:

Symptoms

Alert notification Query is created to return 4 rows in one email, however is returning 4 emails.

Steps to reproduce the issue:

1. PSQuery for Alerts Framework created: in Query Manager, the query is created with the field Emplid, HR_STATUS and SUPERVISOR_ID

2. Alert Definition Setup: based on the query created

3. User List Definition created for alerts: user list definition is created based on role created by the customer.

4. Running the alerts with Query option : Run Selected Queries for the query

 Email Alerts Generated are:

First email:

 1 row

Second email:

 2 rows

Third email:

 3 rows

Fourth email:

 4 rows

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.