Add To Cart Gives Get_customer_tax ORA-06502 Error (Doc ID 728112.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle iStore - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Oct-2010***


Symptoms

When attempting to add an item to cart as a guest user get an unrecoverable error.

The 'View Source' output of the page shows the following error occurs.

ERROR
Message: get_customer_tax- -6502: ORA-06502: PL/SQL: numeric or value error: number precision too
large
Stack:
oracle.apps.jtf.base.resources.FrameworkException: get_customer_tax- -6502: ORA-06502: PL/SQL:
numeric or value error: number precision too large
at oracle.apps.jtf.util.ErrorStackUtil.getFrameworkException(ErrorStackUtil.java:104)
at oracle.apps.jtf.util.ErrorStackUtil.getDBFrameworkException(ErrorStackUtil.java:141)
at oracle.apps.ibe.shoppingcart.quote.Quote.save(Quote.java:6192)
at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7756)
at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1391)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at
com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java
:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2408)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:31)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.jav
a:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: oracle.apps.jtf.base.resources.FrameworkException: get_default_tax_classification-
-6502: ORA-06502: PL/SQL: numeric or value error: number precision too large
at oracle.apps.jtf.util.ErrorStackUtil.getFrameworkException(ErrorStackUtil.java:109)
... 38 more
Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error returned in
ASO_QUOTE_HEADERS_PVT.Create_quote.
... 39 more
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01086: savepoint
'CALCULATE_TAX_WITH_GTT_INT' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_TAX_INT", line 3131
ORA-06502: PL/SQL: numeric or value error: number precision too large
... 39 more
get_customer_tax- -6502: ORA-06502: PL/SQL: numeric or value error: number precision too large
oracle.apps.jtf.base.resources.FrameworkException: get_default_tax_classification- -6502:
ORA-06502: PL/SQL: numeric or value error: number precision too large
at oracle.apps.jtf.util.ErrorStackUtil.getFrameworkException(ErrorStackUtil.java:109)
at oracle.apps.jtf.util.ErrorStackUtil.getDBFrameworkException(ErrorStackUtil.java:141)
at oracle.apps.ibe.shoppingcart.quote.Quote.save(Quote.java:6192)
at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7756)
at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1391)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at
com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java
:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2408)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:31)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.jav
a:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: oracle.apps.jtf.base.resources.FrameworkException: Error returned in
ASO_QUOTE_HEADERS_PVT.Create_quote.
... 39 more
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01086: savepoint
'CALCULATE_TAX_WITH_GTT_INT' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_TAX_INT", line 3131
ORA-06502: PL/SQL: numeric or value error: number precision too large
... 39 more
get_default_tax_classification- -6502: ORA-06502: PL/SQL: numeric or value error: number precision
too large
oracle.apps.jtf.base.resources.FrameworkException: Error returned in
ASO_QUOTE_HEADERS_PVT.Create_quote.
at oracle.apps.jtf.util.ErrorStackUtil.getFrameworkException(ErrorStackUtil.java:109)
at oracle.apps.jtf.util.ErrorStackUtil.getDBFrameworkException(ErrorStackUtil.java:141)
at oracle.apps.ibe.shoppingcart.quote.Quote.save(Quote.java:6192)
at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7756)
at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1391)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at
com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java
:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2408)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:31)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.jav
a:303)
at java.lang.Thread.run(Thread.java:595)
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01086: savepoint
'CALCULATE_TAX_WITH_GTT_INT' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_TAX_INT", line 3131
ORA-06502: PL/SQL: numeric or value error: number precision too large
... 39 more
Error returned in ASO_QUOTE_HEADERS_PVT.Create_quote.
oracle.apps.jtf.base.resources.FrameworkException: ORA-01086: savepoint
'CALCULATE_TAX_WITH_GTT_INT' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_TAX_INT", line 3131
ORA-06502: PL/SQL: numeric or value error: number precision too large
at oracle.apps.jtf.util.ErrorStackUtil.getFrameworkException(ErrorStackUtil.java:109)
at oracle.apps.jtf.util.ErrorStackUtil.getDBFrameworkException(ErrorStackUtil.java:141)
at oracle.apps.ibe.shoppingcart.quote.Quote.save(Quote.java:6192)
at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7756)
at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1391)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at
com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java
:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2408)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:31)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.jav
a:303)
at java.lang.Thread.run(Thread.java:595)
ORA-01086: savepoint 'CALCULATE_TAX_WITH_GTT_INT' never established
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_TAX_INT", line 3131
ORA-06502: PL/SQL: numeric or value error: number precision too large


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