My Oracle Support Banner

ELM 9.2: Nested Program Equivalent Program Tagging Causing SQL error in Exec. (2,280) LECR_PROGRAMCOMPLETION (Doc ID 2396437.1)

Last updated on NOVEMBER 26, 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.


When attempting to run the batch process to enroll for a program
the following error occurs.


SQL error in Exec. (2,280) LECR_PROGRAMCOMPLETION.SectionProgramCompletion.OnExecute Name:checkProg ramItemEquivalent PCPC:8711 Statement:136 Called from:LECR_PROGRAMCOMPLETION.SectionProgramCompletion.OnExecute Name:addNestedProgramRegistra tion Statement:47 Called from:LECR_PROGRAMCOMPLETION.SectionCompletionRule.OnExecute Name:addSectionRegistration Sta tement:34 Called from:LECR_PROGRAMCOMPLETION.ProgramCompletionManager.OnExecute Name:addProgramRegistration Statement:45 Called from:LEEC_ENROL

Steps to Replicate Issue: 

1.  Log in as Administrator

2.  Running AE program (CT_LM_PGM_AE)


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.