Peoplecode Error When Creating A New Course & Specifying Prerequisites (Doc ID 2098417.1)

Last updated on JANUARY 20, 2016

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

While creating a new course & specifying Prerequisites with relationship as “And” or “Or” (and not “End”) as a wrong user input, we are getting the peoplecode error.

If we do the same steps while updating an existing course, then we get a proper error message.

ERROR
-----------------------
Invalid message while SQL transaction in process: The Required Prerequisite list is either missing an end or has data beyond end. (18087,5046) (2,178) LECS.Components.CatalogItemCommon.OnExecute Name:CatalogItemSavePre PCPC:33719 Statement:522
Called from:LECS.Components.LM_CI_LA_CMP.OnExecute Name:CatalogItemSavePre Statement:301
Called from:LM_CI_LA_CMP.GBL.LM_CI_TBL.SavePreChange Statement:1

A PeopleCode program tried to issue the indicated message while an SQL cursor is open. The message is invalid because it requires user input.

Review the PeopleCode and either move the message to a place where it will be issued during user "think-time", or change the "style" so no choice is required.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a new course
Navigation: Main Menu - Enterprise Learning – Catalog - Maintain Courses
2.Add Prerequisites
Prerequisites Type = Course
Relationship = And
(here explicitly entering relationship as “And” as a wrong user input)
3. Click Save

Instead of getting valid error message “The Required Prerequisite list is either missing an end or has data beyond end” , Peoplecode error is shown


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