java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • problem in shared LOV
    via by 680096,
  • Error while testing extended VO
    via by 491697,
  • Regarding an error in the lov
    via by 517595,
  • Using $FLEX$ in iprocurement DFF
    via by user525275,
  • Lov Crashes even b4 reaching to PR
    via by 533926,
  • VO Error: Invalid columnIndex
    via by 528560,
    • java.sql.SQLException: ORA-00904: "COMODITY": invalid identifier at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2548) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2933) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:650) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:578) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:627) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:515) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3347) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(OAJboViewObjectImpl.java:828) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4504) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:574) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:544) at oracle.jbo.server.ViewRowSetImpl.executeDetailQuery(ViewRowSetImpl.java:619) at oracle.jbo.server.ViewObjectImpl.executeDetailQuery(ViewObjectImpl.java:3311) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3298) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:440) at oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:715) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2269) at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1441) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:820) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1346) at oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(OAListOfValuesBean.java:389) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1000) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:966) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:821) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:363) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2658) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1665) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    28 more bugmates