Batch Advisement Reports Are Failing Due Insert Into PS_SAA_RPT_ERROR Table: "ORA-00001: unique constraint (SYSADM.PS_SAA_RPT_ERROR) violated"
(Doc ID 2954621.1)
Last updated on JULY 20, 2023
Applies to:
PeopleSoft Enterprise CS Student Records - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
The Academic Advisement - Generate Report Requests ends with a unique constraint error. The error message is seen in the Process Monitor Message Log.
The issue can be reproduced at will with the following steps:
- Navigate to Academic Advisement > Advisement Processes > Generate Report Requests
- Complete Run Control where Report Type = STD and Report Identifier = ADMIN
- Run the process
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 |