My Oracle Support Banner

E-AWE/EOEN: EOEN Consolidation Alerts and Push Notifications Generate Multiple Emails for each Row of Data Instead of Consolidating into One Email (Doc ID 2736326.1)

Last updated on DECEMBER 15, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.

Symptoms

Sample environment is on PeopleTools (PT) 8.58.05/FSCM 9.2 Image 37. When an EOEN Alert that returns multiple rows of data is set up to consolidate into one email, the emails generated are incorrect. For example, if an alert query returns 7 rows for a user, 1 email containing 7 rows is expected. However, currently, 7 emails are sent - 1st with 1 row, 2nd with 2 rows, 3rd with 3 rows until the final email containing the full consolidation of 7 rows.

Additionally, individual push notification emails are sent for each result row for a total of 14 emails instead of the expected 1 email.

The issue can be reproduced when using EOEN Alert Framework, and triggering the alert as follows:

1) Set up the server for SMTP, ensure Integration Broker (IB) is operational, and EOEN_MSG_CHNL is active.
2) Set VP1's email address to a user's email address -
a. Navigate to PeopleTools > Security > User Profiles > User Profiles.
b. Locate and open VP1 User Profile.
c. Click Edit Email Addresses.
d. Enter a valid email address, click OK, and click Save.

3) Create TEST_ALERT query to return multiple rows for VP1 -
a. Navigate to Reporting Tools > Query > Query Manager.
b. Click Create Query.
c. Enter record name JRNL_HEADER, and click search.
d. Click Add Record next to JRNL_HEADER.
e. On the query tab, select the boxes next to OPRID, Journal ID, and DESCR254.
f. Add the following Criteria:
i. OPRID = VP1
ii. JOURNAL_DATE = 1/1/1999
g. Click on the run tab. Query should return 7 rows.
h. Save the query as a public query named TEST_ALERT.

4) Create Message Catalog Entry for Alert -
a. Navigate to PeopleTools > Utilities > Administration > Message Catalog.
b. Click on "Add a New Value" tab.
c. Enter Message Set Number 25000.
d. Enter sample values as needed and click save

5) Create Alert Definition using consolidate email option -

a. Navigation is Navigator > Enterprise Components > Events & Notifications > Alerts > Alert Definition.
b. Click on the "Add a new value" tab.
c. Enter Query Name = TEST_ALERT, Process Name = EOEN_ALERT, Process Category = CUSTOMEMAIL.

6) Run Alerts -
a. Navigate to Enterprise Components > Events & Notifications > Alerts > Run Alerts.
b. Click on the "Add a new value" tab, and enter “Test”.
c. Enter the other values, and click run.

7) Observe that the user receives many emails.



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
Cause
Solution
References


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