3C Trigger Errors After Upgrading To PT 8.53 (Doc ID 1583888.1)

Last updated on JANUARY 30, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

On : CS9 version, 3C Engines

When attempting to have the online triggers automatically add communications to applicants
the following error occurs sporadically.

ERROR
-----------------------
Error 1: A fatal PeopleCode SQL error occurred. Please consult your system log for details.

Error 2: SQL error in Exec. (2,280) 3CENGINE_LIB.COMMVARD.GBL.default. 1900-01-01. Step02. OnExecute PCPC:919 Statement:4

Error 3: Process 0 ABENDED at Step 3CENGINE_LIB.COMMVARD.Step02(PeopleCode) – RC = 8(108,524).

Error 4: CallAppEngine: Application 3CENGINE_ONL: AppEngine error. (2,653) FUNCLIB_CS_EVENT_3CS_ID.FieldFormula Name: TriggerEngine PCPC:25551 Statement: 380
Called from: FUNCLIB_CS.EVENT_3CS_ID.FieldFormula Name: TriggerProcess Statement: 470
Called from: FUNCLIB_CS.EVENT_3CS_ID.FieldFormula Name: Trigger3CEngine Statement: 528
Called from: ADM_APPL_PROG.EMPLID.SavePostChange Statement: 7

From Trace:
Return: 805 - ORA-00001: unique constraint (ADMIN.PS_ENG_COMMD_TMP3) violated

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

1. setup some specific triggers

2. Add effdated rows to the application with the trigger combinations

3. Get error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot be sure that the applicants are getting the correct emails.

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