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
  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 | 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.*
  3. 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))
  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