My Oracle Support Banner

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

Last updated on AUGUST 02, 2018

Applies to:

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


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

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

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.

The issue has the following business impact:

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


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

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