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 (PoRequisitionSupplierEO.RATE = :2) AND PoRequisitionSupplierEO.REQUISITION_LINE_ID = :1

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by Sandeep Oracle, 1 year ago
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 user10873676, 1 year ago
oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
via Oracle Community by 229220, 4 months ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ReqDistributionsEO.DISTRIBUTION_ID, ReqDistributionsEO.DISTRIBUTION_NUM, ReqDistributionsEO.REQ_LINE_QUANTITY, ReqDistributionsEO.REQ_LINE_AMOUNT
via Oracle Community by chintu, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition oracle.apps.hxc.selfservice.timecard.server.xxaseJobOsnRsnVO of type View Definition not found
via Oracle Community by 348949, 4 months ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoSuchMethodError, msg=oracle.apps.fnd.sso.SSOManager.isUserCreateUpdateAllowed(Loracle/apps/fnd/common/WebAppsContext;)Z
via Oracle Community by 884536, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description
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 (PoRequisitionSupplierEO.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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.