My Oracle Support Banner

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)

Symptoms

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.

ERROR
-----------------------
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




STEPS
-----------------------
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.



Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.