E-EOEN: Alert Notifications are Executed Multiple Times for Each Row Returned by the Alert Definition Criteria and Query (Doc ID 2913295.1)

Last updated on DECEMBER 07, 2022

Applies to:

Symptoms

After upgrading to HCM 9.2 PUM42 and PeopleTools (PT) 8.59.11, the EOEN_ALERT process is triggering the alert notifications every time the alert message is processed, based on the query defined in the Alert Definitions page.  If the query returns 100 rows, the code is being called 101 times - once for the batch process and once each as part of the notification alert message. The alerts were working fine prior to upgrade, from 8.57.24 and HCM 9.2 PUM 35.

Sample environment
--------------------
PeopleTools 8.59.11
HCM 9.2 PUM 42
FSCM 9.2 PUM 45

Sample replication
--------------------------

1. Create a test query to return multiple rows
      a. Navigate to Reporting Tools > Query > Query Manager.
      b. Click Create Query.
      c. Enter record name e.g. PSOPRDEFN, and click search.
      d. Click Add Record
      e. On the query tab, select the boxes next to OPRID
      f. Add the following Criteria:
     g. OPRID like %A%
     h. Click on the run tab. Query should return 2250+ rows.
     i. Save the query as a public query

2. Create Alert Definition
     a. Navigate to Enterprise Components > Events & Notifications > Alerts > Alert Definition.
     b. Click on the "Add a new value" tab.
     c. Enter Query Name used above, Process Name = EOEN_ALERT, Process Category = CUSTOMEMAIL.

3. Run the EOEN_ALERT process
     a. Navigate to Enterprise Components > Events & Notifications > Alerts > Run Alerts.
     b. Click run.

4. Navigate to Process Monitor (PeopleTools > Process Scheduler > Process Monitor), and verify that EOEN_ALERT application engine completed.
5. Navigate to PeopleTools > Integration Broker > Service Operations Monitor > Asynchronous Services
      - confirm that 2250+ instances have been created

Changes

 Upgrading to PT8.58 or PT8.59.

Cause

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