Learner Enrollment Gives Ora-06502, Ora-06512, Ora-20001

(Doc ID 377073.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Learning Management - Version 11.5.10.2 to 12.0.6 [Release 11.5.10 to 12.0]
Information in this document applies to any platform.

Symptoms

When a Learner attempts to enroll in training, the following error occurs.

ERROR
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 3644
ORA-20001: The approver identified by the following parameters is invalid:
originating system PER originating-system ID PER_ID.
Please delete or replace this approver wherever they occur in AME data,
including approval groups, list-modification conditions, and substitution actions. This approver
does not have an entry in wf_roles. (ORIG_SYSTEM_ID=2500)
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 7731
ORA-06512: at line 1

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility: Learner Self-Service
2. Learner Home
3. Catalog
4. Category
5. Course
6. Offering
7. Enroll Class
8. review

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, Learners cannot complete Enrollment in Training.

Verified the issue in the screen shots as noted below:

Exception Details.

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value
error: character string buffer too small
ORA-06512: at "SYS.HTP", line 1469
ORA-06512: at "SYS.HTP", line 1689
ORA-06512: at "APPS.ORACLEAPPS", line 1111
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.ICX_SEC", line 3111
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.HTP", line 1322
ORA-06512: at "SYS.HTP", line 1397
ORA-06512: at "SYS.HTP", line 1689
ORA-06512: at "APPS.ICX_SEC", line 3457
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_UTIL_DISP_WEB", line 3518
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 3644
ORA-20001: The approver identified by the following parameters is invalid:
originating system PER originating-system ID PER_ID.
Please delete or replace this approver wherever they occur in AME data,
including approval groups, list-modification conditions, and substitution actions. This approver
does not have an entry in wf_roles. (ORIG_SYSTEM_ID=2500)
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 7731
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:975)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at
oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:7
28)
at
oracle.apps.per.selfservice.dynamicapprovals.webui.DynamicApprovalsCO.processRequest(DynamicApproval
sCO.java:138)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:581)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.jav
a:247)
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:937)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:904)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.jav
a:247)
at
oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java
:350)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:937)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:904)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.jav
a:247)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1134)
at
oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1
569)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:937)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:904)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.jav
a:247)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:937)
at
oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:904)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:640)
at
oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.jav
a:247)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2297)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1710)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:501)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:422)
at _oa__html._OA._jspService(_OA.java:88)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
at _oa__html._OA._jspService(_OA.java:98)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.HTP", line 1469
ORA-06512: at "SYS.HTP", line 1689
ORA-06512: at "APPS.ORACLEAPPS", line 1111
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.ICX_SEC", line 3111
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.HTP", line 1322
ORA-06512: at "SYS.HTP", line 1397
ORA-06512: at "SYS.HTP", line 1689
ORA-06512: at "APPS.ICX_SEC", line 3457
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_UTIL_DISP_WEB", line 3518
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 3644
ORA-20001: The approver identified by the following parameters is invalid:
originating system PER originating-system ID PER_ID.
Please delete or replace this approver wherever they occur in AME data,
including approval groups, list-modification conditions, and substitution actions. This approver
does not have an entry in wf_roles. (ORIG_SYSTEM_ID=2500)
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 7731
ORA-06512: at line 1

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