When Utilizing Notification Framework, Emails Not Being Sent and Error (2,121) is Encountered (Doc ID 2040727.1)

Last updated on NOVEMBER 07, 2016

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
--------------------------------
When attempting to delegate access, for example, in self service using Share my Information, users get the following message as a pop up, but neither the delegator nor the proxy receives any information:

An email notification will be sent to test. (14025,76)
An email notification will be sent to test to inform him or her about the new or revoked delegated transactions. Press Ok to continue or Cancel to go back.

When reviewing error log, the following is noted:

Notification cannot be sent due to following error:  Notification cannot be sent.  Notification data cannot be saved due to error: Negative number assigned to an unsigned field: SCC_NTFREQ_HDR.SCC_NTFREQ_ID. (2,121)
SCC_COMMON.NOTIFICATION.Accessors.NotificationRequestHeader.OnExecute Name:SCC_NTFREQ_ID PCPC:1112 Statement:21
Called from:SCC_COMMON.NOTIFICATION.Accessors.NotificationRequestHeader.OnExecute Name:populateNotificationReqID Statement:37
Called from:SCC_COMMON.NOTIFICATION.Accessors.NotificationRequestHeader.OnExecute Name:preSave Statement:15
Called from:SCC_COMMON.ENTITY.BasicEntity.OnExecute Name:save Statement:24
Called from:COMMON.NOTIFICATION.Accessors.NotificationRequestHeader.OnExec
(14026,12)

EXPECTED BEHAVIOR
------------------------------------
It is anticipated that an email notification will be received.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Main Menu > Self Service > Student Centre > Share My Information. Click on Delegate Access To A New Contact button.
2: Click on the “I accept” button to accept terms and conditions.
3: Fill in the relevant information and click on the Save button.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, users cannot share information.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms