Graduation Processing Adding Incorrect Student Degree Number When Student is Graduated from More than 10 Programs On The Same Day (Doc ID 2833847.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When a student is processed for graduation using Graduation Processing (SSR_GRAD_RPT) from more than ten careers, each with a unique academic program and academic plan, on the same day,  SSR_GRAD_RPT does not insert degree numbers greater than 9.  The 10th career onward will update ACAD_PLAN.STDNT_DEGR with a value of 1.  The ACAD_DEGR table is updated with only 9 degrees.

The issue can be reproduced at will with the following steps:

1. Navigate to Records and Enrollment, Student/Program Plan;
2. Add an emplid into more than 10 unique career numbers, each with a different academic program and academic plan;
3. Navigate to Records and Enrollment, Graduation, Graduation Processing
4. Select a run control;
5. Populate the run control using a PS Query that will select all career numbers;
6. Submit the process to the process scheduler;
7. Navigate to Records and Enrollment, Graduation, Student Degrees;
8. Select the student;
9. Note only 9 degree records exist;
10. Navigate to Records and Enrollment, Student/Program Plan;
11. Select the student;
12. Click on the Academic Plan tab;
13. Review the Student Degree Nbr field;
14. Note the Academic Programs/Plans processed after the 9th program/plan has Student Degree Nbr = 1.

Cause

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