'INSERT INTO PS_SAA_RPT_ERROR - Unique Constraint' Error When Running an Advising Report after Purging Data using the Purge Process.
(Doc ID 2402648.1)
Last updated on FEBRUARY 24, 2022
Applies to:PeopleSoft Enterprise CS Academic Advisement - Version 9 and later
Information in this document applies to any platform.
After running the SAA_RPT_PURG process, the SAA_RPT_RQST process went into error as it is trying to insert the same key fields into the PS_SAA_RPT_ERROR table.
INSERT INTO PS_SAA_RPT_ERROR - Unique Constraint Violation
The issue can be reproduced at will with the following steps:
- Navigate to Academic Advisement > Student Advisement > Request Advisement Report
- Add a new value and run the report for a student.
- An error will occur.
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