My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

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

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
Symptoms
Cause
Solution
References


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