My Oracle Support Banner

Application Package Code Used By Alerts & Notifications Processing Truncates Email Addresses (Doc ID 1927313.1)

Last updated on JUNE 22, 2022

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


The HCM 9.2 App Package code used by Alerts & Notifications processing truncates email addresses at 60 bytes when multiple email addresses are used on the Alert Setup as for Override Email Notification on page EOEN_NTF_REG_SYS.

The EOEN_ALERT app engine runs successfully and submits messages to the integration broker. The message fails because it is unable to send to a valid email address, since the appended email addresses are truncated at 60 characters. The length of the field EOEN_SRCH_KEY_VALU is only 60 bytes, and it is used in database table EOEN_SRCHKEY which feeds data to the EMAIL_ADDRESS field on EOEN_AL_CTX table.

The issue can be reproduced at will with the following steps:

1. Create a query that will return results.  
2. Create a message for the Alert email.
3. Create the Notification Registry.
4. Create the Notification System Override.
5. Setup the Alert – Query & EWN tab
6. Setup the Alert – URL tab
7. Setup the Alert – Message tab
8. Setup Alert – Email Consolidation tab
9. Setup Alert – Frequency & Product
10. Run the Alert.


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

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