'SAA_ACADEMIC_ADVISEMENT.AA_Report.AA_ReportRequest.OnExecute' Error on Advisement Report Errors for Students with Multiple Plans or a Large Number of Courses on Record (Doc ID 2303461.1)

Last updated on JUNE 07, 2021

Applies to:

Symptoms

On : 9.2 version, Academic Advisement Report

Cannot run advisement reports for a student who is active in 3 academic plans or for students with a large number of courses on the enrollment record. When running the report administratively or in self service, the request does not complete and ends in the following error message.


ERROR
-----------------------

(2,-1) SAA_ACADEMIC_ADVISEMENT.AA_Report.AA_ReportRequest.OnExecute Name:Process_Request PCPC:38775 Statement:512
Called from:SAA_RPT_RQST.GBL.SAA_DERIVED.REPORT_REQUEST_PB.FieldChange Statement:2

The Application Server log will show:

Object Code error : file 'e:\csqal\CBLBINU\SRPCARQL.gnt'
error code: 153, pc=0, call=1, seg=0
153 Subscript out of range (in C:\temp\compile\csflt\SRPCARQL.cbl, line 3216)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Academic Advisement > Student Advisement > Request Advisement Report.
2. Add the request for the affected student and click to submit.
3. Error will occur.

Changes

Cause

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