Adding A Student Application Errors Out with Errors ORA-00001 and (2,653) (Doc ID 2251079.1)

Last updated on APRIL 03, 2017

Applies to:

PeopleSoft Enterprise CS Recruiting and Admissions - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When a user manually adds a student application, it errors as follows:

ERROR
-----------------------
Enter in the required data. Click on "Calculate Application Fees" on the "Application Data" tab.

A sql error has occurred.

The trace log shows the following:

ORA-00001: unique constraint (SYSADM.PS_ENG_COMM_TMP9) violated
CallAppEngine: Application 3CENGINE_ONL: AppEngine error. (2,653)

Application 3CENGINE_ONL: AppEngine error. (2,653) FUNCLIB_CS.EVENT_3CS_ID.FieldFormula Name:TriggerEngine
Called from:FUNCLIB_CS.EVENT_3CS_ID.FieldFormula Name:TriggerProcess
Called from:FUNCLIB_CS.EVENT_3CS_ID.FieldFormula Name:Trigger3CEngine
Called from:ADM_APPL_DATA.EMPLID.SavePostChange


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

1. Go to Student Admissions > Application Entry > Add Application.
2. Enter required data and click on "Calculate Application Fees" on the "Application Data" tab.

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

Due to this issue, users cannot add a new student application.

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