ORA-01086: Savepoint 'CALCULATE_TAX_WITH_GTT_INT' Adding Item to Cart (Doc ID 2110570.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle iStore - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Test:  12.1.3 version, Shopping Cart Related

iStore returned following error when user attempts adding item to cart.

This started after applying the following patches:
19812910:R12.ASO.B
17412190:R12.ASO.B

ERROR
-----------------------
Application Error.

Stack trace shows more errors
-------------------------------
Message: Erro retornado em ASO_QUOTE_HEADERS_PVT.Create_quote.
Stack:
oracle.apps.jtf.base.resources.FrameworkException: Erro retornado em ASO_QUOTE_HEADERS_PVT.Create_quote.
 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:6211)
 at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7765)
 at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1413)
 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
 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:734)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
 at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
 at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
 at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
 at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
 at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
 at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
 at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2482)
 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
 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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
 at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:42)
 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:642)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
 at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01086: O ponto de salvamento 'CALCULATE_TAX_WITH_GTT_INT' nunca foi estabelecido nesta sessão ou é inválido
ORA-06512: em "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: em "APPS.ASO_TAX_INT", line 3443
ORA-06502: PL/SQL: erro: buffer de str
 at oracle.apps.jtf.util.ErrorStackUtil.getFrameworkException(ErrorStackUtil.java:109)
 ... 38 more
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ing de caracteres pequeno demais numérico ou de valor
 ... 39 more
Erro retornado em ASO_QUOTE_HEADERS_PVT.Create_quote.
oracle.apps.jtf.base.resources.FrameworkException: ORA-01086: O ponto de salvamento 'CALCULATE_TAX_WITH_GTT_INT' nunca foi estabelecido nesta sessão ou é inválido
ORA-06512: em "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: em "APPS.ASO_TAX_INT", line 3443
ORA-06502: PL/SQL: erro: buffer de str
 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:6211)
 at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7765)
 at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1413)
 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
 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:734)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
 at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
 at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
 at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
 at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
 at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
 at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
 at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2482)
 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
 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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
 at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:42)
 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:642)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
 at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.apps.jtf.base.resources.FrameworkException: ing de caracteres pequeno demais numérico ou de valor
 ... 39 more
ORA-01086: O ponto de salvamento 'CALCULATE_TAX_WITH_GTT_INT' nunca foi estabelecido nesta sessão ou é inválido
ORA-06512: em "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: em "APPS.ASO_TAX_INT", line 3443
ORA-06502: PL/SQL: erro: buffer de str
oracle.apps.jtf.base.resources.FrameworkException: ing de caracteres pequeno demais numérico ou de valor
 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:6211)
 at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7765)
 at _ibeCScpAddItem._jspService(_ibeCScpAddItem.java:1413)
 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
 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:734)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
 at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
 at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
 at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
 at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
 at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
 at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
 at _ibeCCtpBuyRoute._jspService(_ibeCCtpBuyRoute.java:2482)
 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
 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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
 at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:42)
 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:642)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
 at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
 at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
 at java.lang.Thread.run(Thread.java:662)
ing de caracteres pequeno demais numérico ou de valor




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Access iStore Home page
2. Login
3. Add item to cart > See error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to shop online.

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