java.sql.SQLException: Invalid column index

Oracle Community | billzheng2004 | 7 months ago
  1. 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
  2. 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
  3. 0

    Extended VO errors after upgrading to 12.1.3

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

    Automated exception search integrated into your IDE

  5. 0

    Getting error in customersearchresultsVO in ireceivables screen.

    Oracle Community | 2 years ago | user8984055
    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:1200)
      2. oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:1634)
      3. oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:2221)
      4. oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:1073)
      5. oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:3045)
      6. oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:2917)
      7. oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:2398)
      8. oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:2256)
      9. oracle.jbo.server.QueryCollection.get(QueryCollection.java:1504)
      10. oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:3705)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2815)
      12. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2671)
      13. oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:2912)
      14. oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2094)
      15. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:782)
      16. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:900)
      17. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:814)
      18. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:808)
      19. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
      19 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQuery
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:441)
      1 frame
    5. oracle.apps.per
      EmpViewsPerfAMImpl.initPerformanceDetailsVO
      1. oracle.apps.per.selfservice.mgrviews.server.PerformanceDetailsVOImpl.executeQuery(PerformanceDetailsVOImpl.java:98)
      2. oracle.apps.per.selfservice.mgrviews.server.EmpViewsPerfAMImpl.initPerformanceDetailsVO(EmpViewsPerfAMImpl.java:44)
      2 frames
    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
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
      2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764)
      3 frames
    8. oracle.apps.per
      EmpViewsPerfTblCO.processRequest
      1. oracle.apps.per.selfservice.mgrviews.webui.EmpViewsPerfTblCO.processRequest(EmpViewsPerfTblCO.java:51)
      1 frame
    9. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)
      2. oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2144)
      3. oracle.apps.fnd.framework.webui.beans.table.OATableBean.processRequest(OATableBean.java:1035)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      8. oracle.apps.fnd.framework.webui.beans.layout.OABorderLayoutBean.processRequest(OABorderLayoutBean.java:348)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      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:976)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      18. oracle.apps.fnd.framework.webui.OAQueryHelper.processRequest(OAQueryHelper.java:567)
      19. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      24. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      25. oracle.apps.fnd.framework.webui.OASubTabLayoutHelper.handlePPREvent(OASubTabLayoutHelper.java:1571)
      26. oracle.apps.fnd.framework.webui.OASubTabLayoutHelper.processFormData(OASubTabLayoutHelper.java:603)
      27. oracle.apps.fnd.framework.webui.beans.layout.OASubTabLayoutBean.processFormData(OASubTabLayoutBean.java:470)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      29. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      32. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      33. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormData(OAStackLayoutBean.java:356)
      34. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      37. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      38. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      39. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormData(OAHeaderBean.java:396)
      40. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      41. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      42. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      43. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      44. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      45. oracle.apps.fnd.framework.webui.beans.layout.OABorderLayoutBean.processFormData(OABorderLayoutBean.java:353)
      46. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      47. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      48. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      49. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      50. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      51. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormData(OAStackLayoutBean.java:356)
      52. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      53. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      54. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      55. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      56. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      57. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormData(OAPageLayoutBean.java:1574)
      58. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      59. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      60. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      61. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      62. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      63. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormData(OAFormBean.java:390)
      64. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataIndexedChildren(OAWebBeanHelper.java:1112)
      65. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1068)
      66. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormDataChildren(OAWebBeanHelper.java:1062)
      67. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormData(OAWebBeanHelper.java:782)
      68. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormData(OAWebBeanContainerHelper.java:693)
      69. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormData(OABodyBean.java:358)
      70. oracle.apps.fnd.framework.webui.OAPageBean.processFormData(OAPageBean.java:2902)
      71. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1877)
      72. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
      73. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
      73 frames
    10. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:213)
      1 frame
    11. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    12. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    13. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    14. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    15. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    16. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    17. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
      1 frame
    18. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    19. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
      4 frames
    20. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    21. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame