1 Reply Latest reply: May 24, 2012 4:16 AM by Pankaj RSS

    'ADD_CONFIG_TO_QUOTE_PVT' error for item Configuration

    Hawkeye 11
      Hi,
      I am using Oracle EBS 11i. I have created a CXRule to save a DFF value to CZ_CONFIG_ATTRIBUTES.Used a CXRule function
      to save it on POSTConfigSave event(added a insert query in this function). It is working perfectly in configurator Developer.But getting following error in istore after publishing it.

      Message: ORA-01086: savepoint 'ADD_CONFIG_TO_QUOTE_PVT' never established in this session or is invalid
      ORA-06512: at "APPS.IBE_CFG_CONFIG_PVT", line 345
      ORA-01086: savepoint 'GET_CONFIG_DETAILS_PUB' never established in this session or is invalid
      ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
      ORA-06512: at "APPS.ASO_CFG_PUB", line 164
      ORA-01086: savepoint 'GET_CONFIG_DETAILS_INT' never established in this session or is invalid
      ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
      ORA-06512: at "APPS.ASO_CFG_INT", line 1600
      ORA-01403: no data found
      ORA-06512: at line 1

      Stack:

      java.sql.SQLException: ORA-01086: savepoint 'ADD_CONFIG_TO_QUOTE_PVT' never established in this session or is invalid
      ORA-06512: at "APPS.IBE_CFG_CONFIG_PVT", line 345
      ORA-01086: savepoint 'GET_CONFIG_DETAILS_PUB' never established in this session or is invalid
      ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
      ORA-06512: at "APPS.ASO_CFG_PUB", line 164
      ORA-01086: savepoint 'GET_CONFIG_DETAILS_INT' never established in this session or is invalid
      ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
      ORA-06512: at "APPS.ASO_CFG_INT", line 1600
      ORA-01403: no data found
      ORA-06512: at line 1

           at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
           at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
           at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
           at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
           at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
           at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
           at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
           at oracle.apps.ibe.configurator.ConfiguratorWrapper.addConfigToQuote(ConfiguratorWrapper.java:194)
           at oracle.apps.ibe.configurator.Configurator.addConfigToCart(Configurator.java:357)
           at oa_html._ibeCFgpBranch._jspService(_ibeCFgpBranch.java:880)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:662)

      Please help me in finding out why this error happens and how can solve it.

      Thanks