java.sql.SQLException: ORA-00904: "XXSNT_CLAIM_STATUS_DRAFT": invalid identifier at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code)) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java(Compiled Code)) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java(Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java(Compiled Code))

Oracle Community | user6768197 | 4 years ago
  1. 0

    Error message when we do search for claim in Isupplier

    Oracle Community | 4 years ago | user6768197
    java.sql.SQLException: ORA-00904: "XXSNT_CLAIM_STATUS_DRAFT": invalid identifier at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code)) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java(Compiled Code)) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java(Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java(Compiled Code))
  2. 0

    SQL error during statement preparation

    Oracle Community | 7 years ago | 610323
    java.sql.SQLException: ORA-01843: not a valid month at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code))
  3. 0

    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparat

    Oracle Community | 7 years ago | 610323
    java.sql.SQLException: ORA-01843: not a valid month at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL functions ExistsNode and Extract cannot work in Servlet...

    Oracle Community | 1 decade ago | 185085
    java.sql.SQLException: ORA-00904: invalid column name at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java, Compiled Code) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled Code) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled Code) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java, Compiled Code) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java, Compiled Code) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java, Compiled Code) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java, Compiled Code)
  6. 0

    SQLException: ORA-03120

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java, Compiled Code) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java, Compiled Code) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java, Compiled Code)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-00904: "XXSNT_CLAIM_STATUS_DRAFT": invalid identifier at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(Compiled Code)) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java(Compiled Code)) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java(Compiled Code)) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java(Compiled Code)) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java(Compiled Code)) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java(Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java(Inlined Compiled Code)) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java(Inlined Compiled Code)) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java(Compiled Code))

      at xxsnt.oracle.apps.pos.isp.server.XxsntSupplierClaimsAMImpl.searchclaim()
    2. xxsnt.oracle.apps
      XxsntSupplierClaimsAMImpl.searchclaim
      1. xxsnt.oracle.apps.pos.isp.server.XxsntSupplierClaimsAMImpl.searchclaim(XxsntSupplierClaimsAMImpl.java:120)
      1 frame
    3. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame