My Oracle Support Banner

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

Last updated on DECEMBER 26, 2019

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.



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.