oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PACKING_UNIT_NUM ,PACKING_UNIT_STATUS ,PO_NUM ,PO_LINE ,PROJECT_NUM ,VENDOR_NAME ,CUSTOMER_PLANT ,ITEM_NUMBER ,PARENT_ITEM ,SUPPLIER_REFERENCE ,TERMS_OF_DELIVERY ,DELIVERY_STATUS ,READY_FOR_DISPATCH_ON ,TOTAL_GROSS_WEIGHT ,TOTAL_NET_WEIGHT ,COLLECTION_ADDRESS ,ZIP_CODE_CITY ,COUNTRY ,CONTACT_PERSON ,COUNTRY_OF_ORIGIN ,CARGO_SPEC_NUM ,SHIPMENT_NUM ,LOGISTIC_USER ,DEMAND_SOURCE ,EXPEDITOR_NAME ,BUYER_NAME ,SUPPLY_STATUS ,PO_QTY ,RECEIVED_QTY FROM XXFLS_SWB_CPL FFPU WHERE UPPER(FFPU.PO_NUM)=(NVL(:1,FFPU.PO_NUM)) AND UPPER(FFPU.PACKING_UNIT_NUM)=(nvl(:2,FFPU.PACKING_UNIT_NUM)) AND UPPER(FFPU.VENDOR_NAME) LIKE UPPER(NVL(:3,FFPU.VENDOR_NAME))

Oracle Community | 835862 | 6 years ago
  1. 0

    Reg:Got an exception while getting multiple records for updation

    Oracle Community | 6 years ago | 835862
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PACKING_UNIT_NUM ,PACKING_UNIT_STATUS ,PO_NUM ,PO_LINE ,PROJECT_NUM ,VENDOR_NAME ,CUSTOMER_PLANT ,ITEM_NUMBER ,PARENT_ITEM ,SUPPLIER_REFERENCE ,TERMS_OF_DELIVERY ,DELIVERY_STATUS ,READY_FOR_DISPATCH_ON ,TOTAL_GROSS_WEIGHT ,TOTAL_NET_WEIGHT ,COLLECTION_ADDRESS ,ZIP_CODE_CITY ,COUNTRY ,CONTACT_PERSON ,COUNTRY_OF_ORIGIN ,CARGO_SPEC_NUM ,SHIPMENT_NUM ,LOGISTIC_USER ,DEMAND_SOURCE ,EXPEDITOR_NAME ,BUYER_NAME ,SUPPLY_STATUS ,PO_QTY ,RECEIVED_QTY FROM XXFLS_SWB_CPL FFPU WHERE UPPER(FFPU.PO_NUM)=(NVL(:1,FFPU.PO_NUM)) AND UPPER(FFPU.PACKING_UNIT_NUM)=(nvl(:2,FFPU.PACKING_UNIT_NUM)) AND UPPER(FFPU.VENDOR_NAME) LIKE UPPER(NVL(:3,FFPU.VENDOR_NAME))
  2. 0

    error when run a page from jdev10.1.3.3

    Oracle Community | 9 years ago | 600585
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 0

    Not able to implement 'Attachment' Feature

    Oracle Community | 8 years ago | 608263
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    help regarding null pointer exception

    Oracle Community | 8 years ago | 600585
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    How to disable the next button

    Oracle Community | 7 years ago | 709751
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    11 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.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PACKING_UNIT_NUM ,PACKING_UNIT_STATUS ,PO_NUM ,PO_LINE ,PROJECT_NUM ,VENDOR_NAME ,CUSTOMER_PLANT ,ITEM_NUMBER ,PARENT_ITEM ,SUPPLIER_REFERENCE ,TERMS_OF_DELIVERY ,DELIVERY_STATUS ,READY_FOR_DISPATCH_ON ,TOTAL_GROSS_WEIGHT ,TOTAL_NET_WEIGHT ,COLLECTION_ADDRESS ,ZIP_CODE_CITY ,COUNTRY ,CONTACT_PERSON ,COUNTRY_OF_ORIGIN ,CARGO_SPEC_NUM ,SHIPMENT_NUM ,LOGISTIC_USER ,DEMAND_SOURCE ,EXPEDITOR_NAME ,BUYER_NAME ,SUPPLY_STATUS ,PO_QTY ,RECEIVED_QTY FROM XXFLS_SWB_CPL FFPU WHERE UPPER(FFPU.PO_NUM)=(NVL(:1,FFPU.PO_NUM)) AND UPPER(FFPU.PACKING_UNIT_NUM)=(nvl(:2,FFPU.PACKING_UNIT_NUM)) AND UPPER(FFPU.VENDOR_NAME) LIKE UPPER(NVL(:3,FFPU.VENDOR_NAME))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      8. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      9. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      10. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      13. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      14. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      15. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source)
      16. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      19. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      19 frames