My Oracle Support Banner

Table Validation Report (SFTBLVAL.SQR) Does Not Complete Or Experiences Performance Issues (Doc ID 2297193.1)

Last updated on JANUARY 29, 2019

Applies to:

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

Symptoms

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


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

SQR for PeopleSoft: Program Aborting.


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

 

 

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
References


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