java.sql.SQLException: Invalid column index

Oracle Community | sseth29 | 6 years ago
  1. 0

    R12.1.3 - Error when searching for customer simple search - JBO-27022: Fail

    Oracle Community | 6 years ago | sseth29
    java.sql.SQLException: Invalid column index
  2. 0

    Extended VO errors after upgrading to 12.1.3

    Oracle Community | 3 years ago | elcaro
    java.sql.SQLException: Invalid column index
  3. 0

    Getting error in customersearchresultsVO in ireceivables screen.

    Oracle Community | 2 years ago | user8984055
    java.sql.SQLException: Invalid column index
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Weird AttributeLoadException:JBO-27022 issue after upgrade from 12.1.1 to 12.1.3

    Oracle Community | 7 months ago | billzheng2004
    java.sql.SQLException: Invalid column index

    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.executeQuery
      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.refresh(ViewRowSetIteratorImpl.java:2915)
      14. oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2086)
      15. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:774)
      16. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
      17. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      18. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      19. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
      19 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQuery
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      1 frame
    5. oracle.apps.ar
      HzPuiBaseVOImpl.initQuery
      1. oracle.apps.ar.hz.components.base.server.HzPuiBaseVOImpl.initQuery(HzPuiBaseVOImpl.java:130)
      1 frame
    6. 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
    7. oracle.apps.fnd
      OAViewObjectImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
      2. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1091)
      2 frames
    8. oracle.apps.ar
      HzPuiBaseAMImpl.initQuery
      1. oracle.apps.ar.hz.components.base.server.HzPuiBaseAMImpl.initQuery(HzPuiBaseAMImpl.java:136)
      1 frame
    9. 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
    10. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
      2. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
      2 frames
    11. oracle.apps.ar
      HzPuiBaseCO.processRequest
      1. oracle.apps.ar.hz.components.base.webui.HzPuiSearchResultBaseCO.doSearch(HzPuiSearchResultBaseCO.java:367)
      2. oracle.apps.ar.hz.components.base.webui.HzPuiSearchResultBaseCO.executeDQMQueryPFR(HzPuiSearchResultBaseCO.java:764)
      3. oracle.apps.ar.hz.components.base.webui.HzPuiSearchResultBaseCO.executeDQMQueryPR(HzPuiSearchResultBaseCO.java:692)
      4. oracle.apps.ar.hz.components.search.webui.HzPuiDQMSrchResultsCO.executeQueryPR(HzPuiDQMSrchResultsCO.java:235)
      5. oracle.apps.ar.hz.components.base.webui.HzPuiSearchResultBaseCO.customProcessRequest(HzPuiSearchResultBaseCO.java:86)
      6. oracle.apps.ar.hz.components.base.webui.HzPuiBaseCO.processRequest(HzPuiBaseCO.java:159)
      6 frames
    12. 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.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
      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.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      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.OAFlexibleContentHelper.processRequest(OAFlexibleContentHelper.java:504)
      18. oracle.apps.fnd.framework.webui.beans.OAFlexibleContentBean.processRequest(OAFlexibleContentBean.java:356)
      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.beans.layout.OAFlexibleLayoutBean.processRequest(OAFlexibleLayoutBean.java:357)
      23. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      24. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      26. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      27. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      29. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      31. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      32. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      33. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      34. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      37. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      38. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      39. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      40. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      41. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      42. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      43. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      44. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      45. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1786)
      46. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      47. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      47 frames