oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionSupplierEO.REQUISITION_LINE_ID, PoRequisitionSupplierEO.VENDOR_ID, PoRequisitionSupplierEO.VENDOR_SITE_ID, PoRequisitionSupplierEO.VENDOR_CONTACT_ID, PoRequisitionSupplierEO.NOTE_TO_VENDOR, PoRequisitionSupplierEO.DOCUMENT_TYPE_CODE, PoRequisitionSupplierEO.SOURCE_DOC_HEADER_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_NUM, PoRequisitionSupplierEO.UNIT_PRICE, PoRequisitionSupplierEO.CURRENCY_UNIT_PRICE, PoRequisitionSupplierEO.AMOUNT, PoRequisitionSupplierEO.CURRENCY_AMOUNT, PoRequisitionSupplierEO.CURRENCY_CODE, PoRequisitionSupplierEO.RATE_TYPE, PoRequisitionSupplierEO.RATE_DATE, PoRequisitionSupplierEO.RATE, PoRequisitionSupplierEO.PRICE_BREAK_ID, PoRequisitionSupplierEO.NOT_TO_EXCEED_PRICE, PoRequisitionSupplierEO.ALLOW_PRICE_OVERRIDE_FLAG, PoRequisitionSupplierEO.ALLOW_RATE_DIFFERENTIAL_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_DATE, PoRequisitionSupplierEO.LAST_UPDATE_DATE, PoRequisitionSupplierEO.LAST_UPDATED_BY, PoRequisitionSupplierEO.LAST_UPDATE_LOGIN, PoRequisitionSupplierEO.CREATION_DATE, PoRequisitionSupplierEO.CREATED_BY, PoRequisitionSupplierEO.REQUISITION_SUPPLIER_ID, PoRequisitionSupplierEO.ROWID, PoRequisitionSupplierEO.CANDIDATE_FIRST_NAME, PoRequisitionSupplierEO.CANDIDATE_LAST_NAME, PoRequisitionSupplierEO.UNIT_MEAS_LOOKUP_CODE FROM PO_REQUISITION_SUPPLIERS PoRequisitionSupplierEO WHERE (UnitMeasLookupCode = :2PoRequisitionSupplierEO.RATE = :2) AND PoRequisitionSupplierEO.REQUISITION_LINE_ID = :1

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1039

  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionSupplierEO.REQUISITION_LINE_ID, PoRequisitionSupplierEO.VENDOR_ID, PoRequisitionSupplierEO.VENDOR_SITE_ID
  • via Oracle Community by user11969884, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select * from omaxe_work_order_headers where work_order_number is not null) QRSLT WHERE (PROJECT_NAME =:1 AND CONTRACTOR_NAME=:2)
  • via Oracle Community by 907821, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select po_header_id,line_num from po_lines_all) QRSLT WHERE (PO_HEADER_ID =:1 AND ( LINE_NUM like :2 ))
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionSupplierEO.REQUISITION_LINE_ID, PoRequisitionSupplierEO.VENDOR_ID, PoRequisitionSupplierEO.VENDOR_SITE_ID, PoRequisitionSupplierEO.VENDOR_CONTACT_ID, PoRequisitionSupplierEO.NOTE_TO_VENDOR, PoRequisitionSupplierEO.DOCUMENT_TYPE_CODE, PoRequisitionSupplierEO.SOURCE_DOC_HEADER_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_ID, PoRequisitionSupplierEO.SOURCE_DOC_LINE_NUM, PoRequisitionSupplierEO.UNIT_PRICE, PoRequisitionSupplierEO.CURRENCY_UNIT_PRICE, PoRequisitionSupplierEO.AMOUNT, PoRequisitionSupplierEO.CURRENCY_AMOUNT, PoRequisitionSupplierEO.CURRENCY_CODE, PoRequisitionSupplierEO.RATE_TYPE, PoRequisitionSupplierEO.RATE_DATE, PoRequisitionSupplierEO.RATE, PoRequisitionSupplierEO.PRICE_BREAK_ID, PoRequisitionSupplierEO.NOT_TO_EXCEED_PRICE, PoRequisitionSupplierEO.ALLOW_PRICE_OVERRIDE_FLAG, PoRequisitionSupplierEO.ALLOW_RATE_DIFFERENTIAL_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_FLAG, PoRequisitionSupplierEO.SUPPLIER_NOTIFIED_DATE, PoRequisitionSupplierEO.LAST_UPDATE_DATE, PoRequisitionSupplierEO.LAST_UPDATED_BY, PoRequisitionSupplierEO.LAST_UPDATE_LOGIN, PoRequisitionSupplierEO.CREATION_DATE, PoRequisitionSupplierEO.CREATED_BY, PoRequisitionSupplierEO.REQUISITION_SUPPLIER_ID, PoRequisitionSupplierEO.ROWID, PoRequisitionSupplierEO.CANDIDATE_FIRST_NAME, PoRequisitionSupplierEO.CANDIDATE_LAST_NAME, PoRequisitionSupplierEO.UNIT_MEAS_LOOKUP_CODE FROM PO_REQUISITION_SUPPLIERS PoRequisitionSupplierEO WHERE (UnitMeasLookupCode = :2PoRequisitionSupplierEO.RATE = :2) AND PoRequisitionSupplierEO.REQUISITION_LINE_ID = :1 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:612) at oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2141) at oracle.apps.fnd.framework.webui.beans.table.OATableBean.processRequest(OATableBean.java:1035) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2514) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1895) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:539) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:427)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates