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))

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • help regarding null pointer exception
    via by 600585,
  • How to disable the next button
    via by 709751,
  • Get flexfield value at runtime
    via by user250934,
  • OAMessageLovInputBean Error
    via by user250934,
    • 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(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    14 more bugmates