java.sql.SQLException: ORA-00904: "STATUS_ID": invalid identifier

Oracle Community | 929839 | 5 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

    Error while running the page

    Oracle Community | 5 years ago | 929839
    java.sql.SQLException: ORA-00904: "STATUS_ID": invalid identifier
  2. 0

    Error in simple form

    Oracle Community | 1 decade ago | 534328
    java.sql.SQLException: ORA-00904: "FIRSTFORMEO"."CREATION_DATE": invalid identifier
  3. 0

    Details PAge issues

    Oracle Community | 9 years ago | Rakesh S
    java.sql.SQLException: ORA-00904: "TRANSACTION_ID": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Bind Variable Does Not Exist

    Oracle Community | 7 years ago | user5500620
    java.sql.SQLException: ORA-01006: bind variable does not exist
  6. 0

    Custom Page gives error for one particular FND_USER

    Oracle Community | 9 years ago | Devang Thakkar
    java.sql.SQLException: ORA-01858: a non-numeric character was found where a numeric was expected

  1. rp 1 times, last 2 months ago
26 unregistered visitors
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: "STATUS_ID": invalid identifier

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.parseExecuteFetch
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583)
    3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1141)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2487)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2854)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:622)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:550)
    4 frames
  5. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:627)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:515)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3347)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:825)
    4 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4465)
    1 frame
  7. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574)
    2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544)
    3. oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619)
    4. oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3311)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3298)
    5 frames
  8. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    1 frame
  9. oracle.apps.ak
    SpillAMImpl.initDetails
    1. oracle.apps.ak.spillpr.server.PageVOImpl.initQuery(PageVOImpl.java:36)
    2. oracle.apps.ak.spillpr.server.SpillAMImpl.initDetails(SpillAMImpl.java:59)
    2 frames
  10. 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:324)
    4 frames
  11. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:189)
    2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:152)
    3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:721)
    3 frames
  12. oracle.apps.ak
    SpillCO.processFormRequest
    1. oracle.apps.ak.spillpr.webui.SpillCO.processFormRequest(SpillCO.java:53)
    1 frame
  13. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:799)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1118)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:995)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:961)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:816)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2633)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1659)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
    18 frames