java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier

Oracle Community | 1007055 | 3 years ago
  1. 0

    Admin server running into issues in SOA.

    Oracle Community | 3 years ago | 1007055
    java.sql.SQLSyntaxErrorException: ORA-00904: "TENANT_ID": invalid identifier
  2. 0

    Add VO Extension R12.2.4 ReqLinesNotificationsVO Error

    Oracle Community | 2 years ago | user554920
    java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  3. 0

    VO EXTENSION IN OAF R12.2.3

    Oracle Community | 1 year ago | Syed Abdul Wahab
    java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid number error when extended VO from 12.1.3 to 12.2.5

    Oracle Community | 7 months ago | 2712224
    java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
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.SQLSyntaxErrorException

    ORA-00904: "TENANT_ID": invalid identifier

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.executeQuery
    1. weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
    1 frame
  4. oracle.toplink.internal
    DatabaseAccessor.executeCall
    1. oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:814)
    2. oracle.toplink.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:540)
    3. oracle.toplink.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:468)
    3 frames
  5. oracle.toplink.threetier
    ServerSession.executeCall
    1. oracle.toplink.threetier.ServerSession.executeCall(ServerSession.java:447)
    1 frame
  6. oracle.toplink.internal
    ExpressionQueryMechanism.selectAllRows
    1. oracle.toplink.internal.sessions.IsolatedClientSession.executeCall(IsolatedClientSession.java:117)
    2. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193)
    3. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:179)
    4. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:250)
    5. oracle.toplink.internal.queryframework.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:583)
    6. oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2500)
    7. oracle.toplink.internal.queryframework.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2458)
    7 frames
  7. oracle.toplink.queryframework
    ReadAllQuery.execute
    1. oracle.toplink.queryframework.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:467)
    2. oracle.toplink.queryframework.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:874)
    3. oracle.toplink.queryframework.DatabaseQuery.execute(DatabaseQuery.java:679)
    4. oracle.toplink.queryframework.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:835)
    5. oracle.toplink.queryframework.ReadAllQuery.execute(ReadAllQuery.java:445)
    5 frames
  8. oracle.toplink.internal
    AbstractSession.executeQuery
    1. oracle.toplink.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2265)
    2. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1079)
    3. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1063)
    4. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1037)
    5. oracle.toplink.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1009)
    5 frames
  9. oracle.tip.mediator
    DBLocker.run
    1. oracle.tip.mediator.dispatch.db.DBAccess.getMessageFromDB(DBAccess.java:800)
    2. oracle.tip.mediator.dispatch.db.DBAccess.getDeferredMessages(DBAccess.java:821)
    3. oracle.tip.mediator.dispatch.db.DeferredDBLocker.getLockedMessages(DeferredDBLocker.java:153)
    4. oracle.tip.mediator.common.listener.DBLocker.getLockedMessages(DBLocker.java:173)
    5. oracle.tip.mediator.common.listener.DBLocker.run(DBLocker.java:93)
    5 frames
  10. oracle.integration.platform
    WorkManagerExecutor$1.run
    1. oracle.integration.platform.blocks.executor.WorkManagerExecutor$1.run(WorkManagerExecutor.java:120)
    1 frame
  11. weblogic.work.j2ee
    J2EEWorkManager$WorkWithListener.run
    1. weblogic.work.j2ee.J2EEWorkManager$WorkWithListener.run(J2EEWorkManager.java:184)
    1 frame
  12. weblogic.work
    DaemonWorkThread.run
    1. weblogic.work.DaemonWorkThread.run(DaemonWorkThread.java:30)
    1 frame