java.sql.SQLException: Invalid column index

Oracle Community | 964558 | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    OAF VO Extension

    Oracle Community | 4 years ago | 964558
    java.sql.SQLException: Invalid column index
  2. 0

    Invalid column index

    Oracle Community | 6 years ago | Manoj Madhusoodanan
    java.sql.SQLException: Invalid column index
  3. 0

    Customization error

    Oracle Community | 6 years ago | Manoj Madhusoodanan
    java.sql.SQLException: Invalid column index * at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    1 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

      Invalid column index

      at oracle.jdbc.driver.OracleResultSetImpl.getObject()
    2. Oracle jdbc
      OracleResultSetImpl.getObject
      1. oracle.jdbc.driver.OracleResultSetImpl.getObject(OracleResultSetImpl.java:1042)
      1 frame
    3. oracle.jbo.server
      ViewObjectImpl.getRowCountInRange
      1. oracle.jbo.server.OracleSQLBuilderImpl.doLoadFromResultSet(OracleSQLBuilderImpl.java:1198)
      2. oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1633)
      3. oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
      4. oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1066)
      5. oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3014)
      6. oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2907)
      7. oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:2272)
      8. oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:2130)
      9. oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504)
      10. oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3697)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2818)
      12. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2674)
      13. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2634)
      14. oracle.jbo.server.ViewRowSetIteratorImpl.getRowCountInRange(ViewRowSetIteratorImpl.java:699)
      15. oracle.jbo.server.ViewRowSetImpl.getRowCountInRange(ViewRowSetImpl.java:3195)
      16. oracle.jbo.server.ViewObjectImpl.getRowCountInRange(ViewObjectImpl.java:7027)
      16 frames
    4. oracle.apps.fnd
      OATableBean.prepareForRendering
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.getRowCountInRange(OAViewObjectImpl.java:1981)
      2. oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.adjustViewRange(OAWebBeanBaseTableHelper.java:226)
      3. oracle.apps.fnd.framework.webui.OATableHelper.prepareNavigatorProperties(OATableHelper.java:1652)
      4. oracle.apps.fnd.framework.webui.OATableHelper.prepareForRendering(OATableHelper.java:513)
      5. oracle.apps.fnd.framework.webui.beans.table.OATableBean.prepareForRendering(OATableBean.java:1220)
      5 frames
    5. oracle.apps.ap
      TrackExpenseReportsCO.processRequest
      1. oracle.apps.ap.oie.webui.TrackExpenseReportsCO.processRequest(TrackExpenseReportsCO.java:157)
      1 frame
    6. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      18. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      23. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      24. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      28. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      29. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      34. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      35. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      36. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      37. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      38. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      38 frames