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.

Oracle Community | user243722 | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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.
  2. 0

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

    Oracle Community | 6 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.*
  3. 0

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

    Oracle Community | 4 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))
  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
    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.
  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 22 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.ap
      NotifExpLinesCO.processRequest
      1. oracle.apps.ap.oie.workflow.apexp.webui.NotifExpLinesCO.processRequest(NotifExpLinesCO.java:116)
      1 frame
    4. oracle.apps.fnd
      OAWebBeanHelper.processRequest
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      1 frame