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

Oracle Community | user8984055 | 2 years ago
  1. 0

    Getting error in customersearchresultsVO in ireceivables screen.

    Oracle Community | 2 years ago | user8984055
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 33 with java object of type java.lang.String due to java.sql.SQLException.
  2. 0

    Failed to load value at index 22 with java object of type java.lang.String

    Oracle Community | 5 years ago | user243722
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 22 with java object of type java.lang.String due to java.sql.SQLException.
  3. 0

    When clicking iProcurement JBO-27022: Failed to load value at index Error

    Oracle Community | 5 years ago | 755639
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 20 with java object of type java.lang.String due to java.sql.SQLException.*
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-27122: SQL error during statement preparation. Statement - In Receiving VO

    Oracle Community | 3 years ago | ORA_USER1122
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (select lookup.meaning from fnd_lookup_values_vl lookup where lookup.lookup_code = rcv.order_type_code and lookup.lookup_type ='POR_RCV_ORDER_TYPE') ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, decode(req_distribution_id, to_number(null), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(null) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT, QUANTITY_INVOICED, GL_ENCUMBERED_DATE, (select hla.location_code from hr_locations_all hla where hla.location_id = rcv.deliver_to_location_id)DAI_LOCATION_CODE from por_rcv_my_purchase_items_v rcv UNION ALL select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (select lookup.meaning from fnd_lookup_values_vl lookup where lookup.lookup_code = rcv1.order_type_code and lookup.lookup_type ='POR_RCV_ORDER_TYPE') ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, NULL matching_basis, decode(req_distribution_id, to_number(null), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(null) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT, QUANTITY_INVOICED, GL_ENCUMBERED_DATE, (select hla.location_code from hr_locations_all hla where hla.location_id = rcv1.deliver_to_location_id)DAI_LOCATION_CODE from por_rcv_internal_items_v rcv1) QRSLT WHERE (REQUESTOR_ID = :1 and expected_receipt_date >= trunc(sysdate - 8) and expected_receipt_date <= trunc(sysdate + 1))
  6. 0

    Error occurs when creating custom integrator

    Oracle Community | 4 years ago | Jackie Han-Oracle
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0

    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 33 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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
      5 frames
    3. oracle.apps.ar
      SystemCustSearchCO.processRequest
      1. oracle.apps.ar.irec.common.webui.SystemCustSearchCO.processRequest(SystemCustSearchCO.java:170)
      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.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      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.OACellFormatBean.processRequest(OACellFormatBean.java:411)
      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.OARowLayoutBean.processRequest(OARowLayoutBean.java:347)
      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.beans.layout.OATableLayoutBean.processRequest(OATableLayoutBean.java:353)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      23. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      24. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      27. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      28. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      29. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      32. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      33. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      34. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      37. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      38. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      39. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      40. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      41. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      42. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      43. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
      44. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      45. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      46. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      47. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      48. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      49. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      50. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)
      51. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)
      52. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)
      53. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      54. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      55. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2630)
      56. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1950)
      57. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:550)
      58. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:438)
      58 frames
    5. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      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
      ServletRequestDispatcher$2.oc4jRun
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
      4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
      5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
      5 frames
    10. oracle.oc4j.security
      OC4JSecurity.doPrivileged
      1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
      1 frame
    11. com.evermind.server
      EvermindPageContext.forward
      1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
      2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
      2 frames
    12. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:221)
      1 frame
    13. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    14. 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
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    16. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    17. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    18. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    19. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    20. 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
    21. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    22. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    23. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:662)
      1 frame