'Invalid column name 'KEY_CHAR_40_01' Error Running the Graduation Report (SRGRDDRV.sqr).

(Doc ID 2274168.1)

Last updated on JUNE 06, 2017

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9 and later
Information in this document applies to any platform.


On : 9 version, Graduation Reporting

When running the Records and Enrollment > Graduation > Graduation Report to award degrees, the process ends with the following error:

Inserting row 1.000000 into Batch Delay Record for Record: ACAD_PROG - Keys:EMPLID ACAD_CAREER STDNT_CAR_NBR EFFDT EFFSEQ Values :1002656 UGRD 0 2017-05-18 0 Audit Action:A
e:\psoft\cs90prd\sqr\srgrddrv.sqr: - SQL Statement =
SQL Status = 207, SQL Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'KEY_CHAR_40_01'.

Error on line 71:
  (SQR 3301) Program stopped by user request.

SQR for PeopleSoft: Program Aborting.

The issue can be reproduced at will with the following steps:
1. Navigate to Records and Enrollment > Graduation > Graduation Report.
2. Select the run control values to update Student Program Plan to Awarded.
3. Run the report.

The issue has the following business impact:
Due to this issue, users cannot run the graduation report.


 Issue started after applying CS 9 Bundle #44.


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