Class Roster performance poor after applying CS Bundle #34

(Doc ID 2063645.1)

Last updated on NOVEMBER 01, 2017

Applies to:

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

Symptoms

ISSUE STATEMENT
---------------
After applying CS 9.0 Bundle #34, customers have noted a significant decrease in performance of the Class Roster and Grade Roster components. In particular, CLASS_ROSTER_VW view is consuming excessive amounts of CPU.
  

ENVIRONMENT
---------------
DB Platform: Generic
Tools Version: 8.53.12+
Application & Version: PeopleSoft Enterprise Campus Solutions 9 Bundle 34 and beyond
 
 
STEPS
---------------
The issue can be reproduced with the following steps:
1. Attempt to view a class roster that lists more than 100 students. Note the time to load into the component prior and after applying CS Bundle #34.
 
IMPACT
---------------
Customers are finding some class rosters will not load at all. Where rosters load, the load is so slow that faculty and users are unable to make use of the Class Roster functionality.

Changes

 Problem occurs after applying CS Bundle #34.

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