My Oracle Support Banner

ELM 9.2: When Performing Search on Administer Class Roster, Receive Error : A fatal PeopleCode SQL error occurred. SQL error in Exec. (2,280) (Doc ID 2214947.1)

Last updated on JUNE 12, 2021

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


From the Class Roster page, when attempting to search for a Learner to enroll in a Class, receive an error message.


A fatal PeopleCode SQL error occurred. Please consult your system log for details.

SQL error in Exec. (2,280) LM_PAGINATION.LM_PAGINATION.OnExecute Name:getCount PCPC:3711 Statement:110
Called from:LM_PAGINATION.LM_PAGINATION.OnExecute Name:getFirstTimeData Statement:276
Called from:LM_ACT_ROSTER.Activate Statement:94

Steps to Replicate Issue: 

1) Log in as an Administrator
2) Navigate to: Main Menu > Enterprise Learning > Learner Tasks > Administer Class Rosters
3) {search for Class}
4) Click on Roster button next to Class
5) Click on Search Options link
6) Enter First Name and/or Last Name and click Search button
7) Get SQL error message pop-up, click OK, and receive PeopleCode error message




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.