My Oracle Support Banner

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

Last updated on MAY 08, 2018

Applies to:

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

Symptoms

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

ERROR
-----------------------

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
-----------------------
The issue can be reproduced at will with the following steps:
1. Running AE program (CT_LM_PGM_AE)




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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.