Getting Error When Clicking On Finish/ Submit Test oracle.apps.fnd.framework.OAException: oracle.apps.fnd.common.PoolException: Not able to create new database connection.

(Doc ID 2346958.1)

Last updated on JANUARY 09, 2018

Applies to:

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

Symptoms

On : 12.2.5 version, Learner Component


When trying to submit a test, getting below error:

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


Error Page
 
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.apps.fnd.common.PoolException: Not able to create new database connection.
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1178)
at oracle.apps.fnd.framework.webui.OAPageBean.handleExceptionInFinalizeRequest(OAPageBean.java:4886)
at oracle.apps.fnd.framework.webui.OAPageBean.finalizeRequest(OAPageBean.java:4818)
at _pages.__oa._jspService(__oa.java:267)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)

When clicked on return to home page, got below error:

Error

java.sql.SQLException: ORA-20001: The QuickCode is invalid for DELEGATE_FAILURE_REASON (PROCEDURE= ota_general.check_domain_value) (STEP=5) ORA-06512: at "APPS.OTA_DELEGATE_BOOKING_API", line 3144 ORA-06512: at "APPS.OTA_TDB_API_UPD2", line 537 ORA-06512: at "APPS.OTA_LO_UTILITY", line 582 ORA-06512: at "APPS.OTA_LO_UTILITY", line 641 ORA-06512: at "APPS.OTA_LO_UTILITY", line 973 ORA-06512: at "APPS.OTA_LO_UTILITY", line 1186 ORA-06512: at "APPS.OTA_LO_UTILITY", line 1296 ORA-06512: at "APPS.OTA_LO_UTILITY", line 1308 ORA-06512: at line 1

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Learner self-service
2. My Learning
3. Learner Home
4. Select the assessment and try to play.


Changes

 

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