oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 70 with java object of type java.lang.String due to java.sql.SQLException.

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
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 70 with java object of type java.lang.String due to java.sql.SQLException.
  2. 0

    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

    Oracle Community | 11 months ago | 2709643
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LSI_CODE_ORIGINAL, LSI_CODE, DESCRIPTION, BU_CODE_ORIGINAL, BU_CODE, BU_NAME, ENABLED_FLAG FROM TRIN_LSI_TO_BU_MAP_V WHERE LSI_CODE LIKE NVL(:1,LSI_CODE) AND BU_CODE LIKE NVL(:2,BU_CODE) AND ENABLED_FLAG LIKE NVL(:3,ENABLED_FLAG)
  3. 0

    OAF Personalization exception

    Oracle Community | 3 months ago | 2906075
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 113 with java object of type oracle.jbo.domain.Date due to java.sql.SQLException.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.lang.ArrayIndexOutOfBoundsException when retainAM is set to true

    Oracle Community | 9 years ago | 581840
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 2

    2 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. oracle.apps.fnd.framework.OAException

      oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 70 with java object of type java.lang.String due to java.sql.SQLException.

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764)
      6 frames
    3. oracle.apps.per
      EmpViewsPerfTblCO.processRequest
      1. oracle.apps.per.selfservice.mgrviews.webui.EmpViewsPerfTblCO.processRequest(EmpViewsPerfTblCO.java:51)
      1 frame
    4. 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
    5. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:213)
      1 frame
    6. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    7. 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
    8. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    9. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    10. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    11. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    12. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
      1 frame
    13. 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
    14. 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
    15. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame