iStore User Registration Page Returns An Application Error (ORA-06502: PL/SQL: numeric or value error: character string buffer too small) (Doc ID 1362322.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle iStore - Version 12.1.2 and later
Information in this document applies to any platform.
ORA-06502
internal error

Symptoms

On : 12.1.2 version, User Registration

When attempting to register a user in iStore, the following error occurs.

ERROR (Html Source)

ORA-06502: PL/SQL: numeric or value error: character string buffer too small




STEPS
-----------------------
1. Go to iStore
2. Try to register a user


Error Stack:

Message: The user could not be registered at this time due to an internal error
Please contact the system administrator if this problem persists.
Note to System Administrators: View source for more information about this
error.
Stack:
oracle.apps.jtf.base.resources.FrameworkException: The user could not be registered at this time due to an internal error
Please contact the system administrator if this problem persists.
Note to System Administrators: View source for more information about this
error.
at oracle.apps.jtf.um.template.TmplUtils.action(TmplUtils.java:389)
at _jtftmplh._jspService(_jtftmplh.java:2389)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
at _jtftmplh._jspService(_jtftmplh.java:2850)
...
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
Caused by: oracle.apps.jtf.base.resources.FrameworkException: IBE_ERR_UM_REG_USER
at oracle.apps.ibe.um.RegisterIndividual.handle(RegisterIndividual.java:498)
at oracle.apps.jtf.um.template.TmplUtils.action(TmplUtils.java:362)
... 63 more
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.IBE_WORKFLOW_PVT", line 1619
ORA-06512: at "APPS.IBE_WORKFLOW_PVT", line 1295
ORA-06512: at line 1
at oracle.apps.jtf.base.resources.FrameworkException.convertException(FrameworkException.java:607)
...
at oracle.apps.jtf.base.resources.FrameworkException.<init>(FrameworkException.java:249)
... 65 more

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