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.
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:
- Navigate in self service to Program Enrollment -> My Education Plan - Course groups
- Note error
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