My Oracle Support Banner

PE: SS - Coursegroups With Large Values Is Giving Error ORA-01795 maximum number of expressions in a list is 1000 (Doc ID 2629814.1)

Last updated on JANUARY 22, 2020

Applies to:

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

Symptoms

Campus Solution 9.2 version, Student Records Additional Features

When attempting to navigate in Self Service when there are course groups with large values
the following error occurs.


A system error occurred, please consult your system log for details.

Trace file shows error of:
 Return: 1795 - ORA-01795: maximum number of expressions in a list is 1000


The issue can be reproduced at will with the following steps:

  1.  Navigate in self service to Program Enrollment -> My Education Plan - Course groups
  2.  Note error




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