Table Validation Report (SFTBLVAL.SQR) Does Not Complete on Campus Solutions 9.2

(Doc ID 2297193.1)

Last updated on AUGUST 15, 2017

Applies to:

PeopleSoft Enterprise CS Student Financials - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On Campus Solutions 9.2, the Table Validation report (SFTBLVAL.SQR) is failing when run for All students, in report mode, with the Item Due options selected.

(SQR 1500) Array element out of range (100000) for array item_due_date on line 3581.

SQR for PeopleSoft: Program Aborting.

The issue can be reproduced at will with the following steps:
1. Navigate to Student Financials, Charges and Payments, Validate Tables;
2. Select a run control;
3. Populate the run control as required;
4. Submit the process to the process scheduler.

PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms