Add Item To Cart That Already Has Promotional Item Added Previously, It Gives Application Error. (Doc ID 1589212.1)

Last updated on JULY 11, 2022

Applies to:

Symptoms

On : 12.1.3 version, Shopping Cart Related

When attempting to add an item that already has an added promotional item added to cart, the following error occurs.

ERROR
-----------------------
Message: An unexpected error has occured during processing of the ASO_QUOTE_HEADER information.
Stack:
oracle.apps.jtf.base.resources.FrameworkException: An unexpected error has occured during processing of the ASO_QUOTE_HEADER information.
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 _tnv__ibeCScpAddItem._jspService(_tnv__ibeCScpAddItem.java:1514)
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 _t__ibeCCtpBuyRoute._jspService(_t__ibeCCtpBuyRoute.java:2563)
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.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
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: savepoint 'UPDATE_QUOTE_PUB' never established in this session or is invalid
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_QUOTE_PUB", line 5589
ORA-01086: savepoint 'UPDATE_QUOTE_PVT' never established in in Package IBE_Quote_Save_pvt Procedure SAVE


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add an item that has a promotional item attached to it.
2. Try to add the same item again

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.