My Oracle Support Banner

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.


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

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


 The issue began after applying CS Bundle #35.


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

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