Enroll Learner - ORA-06511: PL/SQL: Cursor Already Open (Doc ID 2068442.1)

Last updated on MARCH 31, 2017

Applies to:

Oracle Learning Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 (R12.HR_PF.C.delta.6 ) version, Catalog Admin


Enroll Learner - Learner Home > Navigate to course > click enroll= Error: - ORA-06511: PL/SQL: cursor already open


If a course has an advisory or mandatory prerequisite, and the learner attempts enrollment (or admin attempts to single enroll) it results in ORA-06511: PL/SQL: cursor already open error upon clicking enroll icon.

Note* Existing course with pre-prerequisite that the customer brought in works. Any new prerequisites that the customer adds, result in error if it's advisory it's the sys admin generic error (diagnostics into PL/SQL: cursor already open). If mandatory prerequisites it goes straight to the error PL/SQL: cursor already .

 

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

Exception Error: oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06511: PL/SQL: cursor already open
ORA-06512: at "APPS.OTA_CPR_UTILITY", line 258
ORA-06512: at "APPS.OTA_CPR_UTILITY", line 294
ORA-06512: at "APPS.OTA_CPR_UTILITY", line 407
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)



## Detail 0 ##
java.sql.SQLException: ORA-06511: PL/SQL: cursor already open
ORA-06512: at "APPS.OTA_CPR_UTILITY", line 258
ORA-06512: at "APPS.OTA_CPR_UTILITY", line 294
ORA-06512: at "APPS.OTA_CPR_UTILITY", line 407
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)






STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Personalizations Off
Functional Admin > Clear All Cache
Learner Self-Service > Learner Home > Navigate to course > click enroll
Reproduce error






BUSINESS IMPACT
-----------------------

Due to this issue, upgrading from 12.1 to 12.2 and this prevents any admins from using prereqs on their courses.

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