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
The issue can be reproduced at will with the following steps:
- Go to Student Admissions > Application Entry > Add Application.
- 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