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

Oracle Community | 726170 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    EO - VO Mapping (Urgent)

    Oracle Community | 6 years ago | 726170
    java.sql.SQLSyntaxErrorException: ORA-00904: "INSTANCE_ID": invalid identifier
  2. 0

    in indices() function gives 'ORA-01722: invalid number' error

    Stack Overflow | 2 years ago | user3181365
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. 0

    Invalid identifier when connecting to oracle

    GitHub | 3 years ago | afrad
    java.sql.SQLSyntaxErrorException: ORA-00904: "S1"."ID": Invalid Identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLSyntaxErrorException: ORA-00904 : i... | Oracle Community

    oracle.com | 1 year ago
    java.sql.SQLSyntaxErrorException: ORA-00904: "XXXXXXXX"."YYYYYYYYY"."ZZZZZZZZ": invalid identifier
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: "INSTANCE_ID": invalid identifier

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. oracle.jbo.server
    EntityImpl.doSelect
    1. oracle.jbo.server.OracleSQLBuilderImpl.doEntitySelect(OracleSQLBuilderImpl.java:730)
    2. oracle.jbo.server.EntityImpl.doSelect(EntityImpl.java:5594)
    2 frames
  4. oracle.apps.fnd
    OAPlsqlEntityImpl.doSelect
    1. oracle.apps.fnd.framework.server.OAEntityImpl.doSelect(OAEntityImpl.java:1767)
    2. oracle.apps.fnd.framework.server.OAPlsqlEntityImpl.lockRow(OAPlsqlEntityImpl.java:347)
    3. oracle.apps.fnd.framework.server.OAPlsqlEntityImpl.doSelect(OAPlsqlEntityImpl.java:358)
    3 frames
  5. oracle.jbo.server
    EntityImpl.lock
    1. oracle.jbo.server.EntityImpl.lock(EntityImpl.java:3847)
    1 frame
  6. oracle.apps.fnd
    OAEntityImpl.lock
    1. oracle.apps.fnd.framework.server.OAEntityImpl.lock(OAEntityImpl.java:553)
    1 frame
  7. oracle.jbo.server
    EntityImpl.postChanges
    1. oracle.jbo.server.EntityImpl.beforePost(EntityImpl.java:4328)
    2. oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4472)
    2 frames
  8. oracle.apps.fnd
    OAEntityImpl.postChanges
    1. oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1759)
    1 frame
  9. oracle.jbo.server
    DBTransactionImpl.commit
    1. oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:2996)
    2. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2807)
    3. oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1971)
    4. oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
    4 frames
  10. oracle.apps.fnd
    OADBTransactionImpl.commit
    1. oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690)
    1 frame
  11. oracle.apps.ahl
    OspOrderAMImpl.saveOsp
    1. oracle.apps.ahl.osp.server.OspOrderAMImpl.saveOsp(OspOrderAMImpl.java:208)
    1 frame
  12. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  13. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
    2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
    3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
    3 frames
  14. oracle.apps.ahl
    OspOrderCO.processFormRequest
    1. oracle.apps.ahl.osp.webui.OspOrderCO.processFormRequest(OspOrderCO.java:447)
    1 frame
  15. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:815)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1189)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1027)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:993)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:848)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:382)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2861)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1838)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
    18 frames