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

Oracle Community | 680096 | 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

    problem in shared LOV

    Oracle Community | 6 years ago | 680096
    java.sql.SQLException: ORA-00904: "COMODITY": invalid identifier
  2. 0

    problem with seeded extension example - adding supplier site

    Oracle Community | 1 decade ago | 491697
    java.sql.SQLException: ORA-01722: invalid number
  3. 0

    Error while testing extended VO

    Oracle Community | 1 decade ago | 491697
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Regarding an error in the lov

    Oracle Community | 1 decade ago | 517595
    java.sql.SQLException: ORA-00936: missing expression
  6. 0

    Using $FLEX$ in iprocurement DFF

    Oracle Community | 1 decade ago | user525275
    java.sql.SQLException: ORA-00911: invalid character

  1. rp 1 times, last 5 months ago
27 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: "COMODITY": 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:1986)
    4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
    4 frames
  4. Oracle jdbc
    OraclePreparedStatement.executeQuery
    1. oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2548)
    2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2933)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650)
    4. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578)
    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:828)
    4 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4504)
    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
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:440)
    2. oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:715)
    3. oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2269)
    4. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1441)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:820)
    6. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    7. oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1346)
    8. oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(OAListOfValuesBean.java:389)
    9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1000)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:966)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:821)
    12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363)
    13. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    14. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2658)
    15. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1665)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)
    17 frames