2 Replies Latest reply: Aug 16, 2012 12:05 AM by 933676 RSS

    savepoint 'SAVE_PVT' never established in this session or is invalid

    933676
      In IE while doing check out I am getting the following error. Please see the stack trace.Anyone can suggest why is this happening?


      Message: ORA-01086: savepoint 'SAVE_PVT' never established in this session or is invalid
      ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 4919
      ORA-01086: savepoint 'UPDATE_QUOTE_PUB' never established in this session or is invalid
      ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
      ORA-06512: at "APPS.ASO_QUOTE_PUB", line 3759
      ORA-06510: PL/SQL: unhandled user-defined exception
      ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 4123
      ORA-06512: at "APPS.IBE_QUOTE_W1_PVT", line 5729
      ORA-06512: at line 1

      Stack:

      java.sql.SQLException: ORA-01086: savepoint 'SAVE_PVT' never established in this session or is invalid
      ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 4919
      ORA-01086: savepoint 'UPDATE_QUOTE_PUB' never established in this session or is invalid
      ORA-06512: at "APPS.ASO_UTILITY_PVT", line 107
      ORA-06512: at "APPS.ASO_QUOTE_PUB", line 3759
      ORA-06510: PL/SQL: unhandled user-defined exception
      ORA-06512: at "APPS.IBE_QUOTE_SAVE_PVT", line 4123
      ORA-06512: at "APPS.IBE_QUOTE_W1_PVT", line 5729
      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.executeFetch(TTC7Protocol.java:977)
           at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2205)
           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)