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

Last updated on JULY 07, 2020

Applies to:

Symptoms

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.

STEPS to REPLICATE
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.

Cause

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