3 Replies Latest reply: Dec 21, 2011 12:45 AM by Hawkeye 11 RSS

    Add to Cart Error

    Hawkeye 11
      Hi ,

      When I tried to add a product from catalog to cart as a B2B user getting following application Error,

      oracle.apps.jtf.base.resources.FrameworkException: ORA-01403: no data found in Package IBE_Quote_Save_pvt Procedure SAVE
           at oracle.apps.ibe.shoppingcart.quote.Quote.save(Quote.java:6218)
           at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.addItemsToCart(ShoppingCart.java:7765)
           at ibeCScpAddItem.jspService(_ibeCScpAddItem.java:1580)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
           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 ibeCCtpBuyRoute._jspService(ibeCCtpBuyRoute.java:2742)
           at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
           at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
           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:621)
           at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
           at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:889)
           at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
           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:619)
      ORA-01403: no data found in Package IBE_Quote_Save_pvt Procedure SAVE

      Application Version :12.1.3
      OS : Linux;
      DB : Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

      Please help me to fix this issue .

      Thanks
      Mark

      Edited by: Mark on Dec 21, 2011 11:42 AM