Unique Constraint Errors Running Advisement Reports or Updating Self Service Reports
(Doc ID 2493744.1)
Last updated on DECEMBER 19, 2019
Applies to:PeopleSoft Enterprise CS Academic Advisement - Version 9.2 and later
Generic (Platform Independent)
On : 9.2 version, Academic Advisement Self Service
The following error is received when running Update Self-Service Reports process. The process fails for several students.
Remote program SRPCAARC failed with reason: 2500-COURSE-AVAILABLE (2,-1) SAA_ACADEMIC_ADVISEMENT.AA_Report.AA_ReportRequest.OnExecute Name:Process_Request PCPC:39063 Statement:518
Called from:SAA_RPT_RQST.GBL.SAA_DERIVED.REPORT_REQUEST_PB.FieldChange Statement:3
Application Program Failed
In Pgm Section : 2500-COURSE-AVAILABLE
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_SAA_ADB_CRSEAVL) violated
The issue can be reproduced at will with the following steps:
1. Navigate to Academic Advisement > Advisement Processes > Update Self Service Reports.
2. Run the process.
3. Error occurs.
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