SQL Error when Clicking Class Search Detail link after Application of CS Bundle #35 if Class Association value is 9999 (Doc ID 1946627.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms

 Class search detail link returns an error on classes where the Associated Class Number is 9999:

ERROR
---------------
SQLExec: 0 select list items in parameter list, but SQL has 1 select columns (2,124)
SSR_AIR.Components.SSR_VIEW_TREE.OnExecute Name: identify Tree
Called from: SSR_CLASS.Components.CLASS_SEARCH.OnExecute Name: SSR_CLSRCH_DTL_Activate
SSR_AIR.Components.SSR_VIEW_TREE.OnExecute
 
This occurs after the application of CS 9 Bundle #35 / Patch ID 19357125


The issue can be reproduced with the following steps:
1. Create a class with two sections. One is the non-enrollment section with associated class value of 9999.
2. Perform a class search. Click on the Class Details link for the class with associated class value of 9999.

Notice error.
 

Changes

 The issue began after applying CS Bundle #35.

Cause

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