oracle.apps.fnd.framework.OAException: 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, pol.unit_meas_lookup_code, pol.quantity, pol.unit_price, pol.quantity * pol.unit_price total, poh.segment1 po_num, poh.currency_code, pol.item_id, fsp.inventory_organization_id, msi.segment1 segment1, pol.from_header_id, pola.closed_code, pola.cancel_flag, pola.closed_flag, pola.user_hold_flag, pol.attribute1, pol.attribute2, pol.attribute3, pol.attribute4, pol.attribute5, pol.attribute6, pol.attribute7, pol.attribute8, pol.attribute9, pol.attribute10, pol.attribute11, pol.attribute12, pol.attribute13, pol.attribute14, pol.attribute15, pol.attribute_category, pol.note_to_vendor, poh2.segment1 contract_num, pol.item_revision, pol.ussgl_transaction_code, NULL un_number, NULL hazard_class, pol.quantity_committed, pol.committed_amount, pol.expiration_date, NVL (pocr.new_price, pol.unit_price) new_price, NVL (pocr.new_supplier_part_number, pol.vendor_product_num ) new_supplier_part_number, pocr.request_status, 0 viewshipments, 'SItemType', 'PriceType', 'LineStatus', NVL (pos_get.get_item_config (pol.item_id, fsp.inventory_organization_id ), 'F' ) conf_flag, NULL ga_number, pocr.request_reason, DECODE (pocr.request_status, NULL, polc.displayed_field, fnd_message.get_string ('POS', 'POS_PENDING_CHANGE') ) line_display, pol.hazard_class_id, pol.un_number_id, NULL conf_details, 'REASON_TYPE', pol.job_id, pol.contractor_first_name, pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE', polt.order_type_lookup_code line_type, pj.NAME job_title, poh.global_agreement_flag, poh.type_lookup_code, 'ENTITY_TYPE', polt.line_type line_type_dsp, pa.job_description, NULL contractor_name, pol.amount line_amount, pol.supplier_ref_number, DECODE (pol.po_line_id, pol.line_num), 0, NULL, '@' ) archived_attachment FROM po_lines_archive_all pol, po_lines_all pola, po_headers_all poh, mtl_system_items_kfv msi, financials_system_params_all fsp, po_lookup_codes polc, po_change_requests pocr, po_line_types polt, per_jobs pj, po_job_associations pa, po_headers_all poh2 WHERE poh.po_header_id = pol.po_header_id AND poh.po_header_id = pola.po_header_id AND poh.po_header_id = poh.po_header_id + 0 AND pol.contract_id = poh2.po_header_id(+) AND pol.latest_external_flag = 'Y' AND pol.po_line_id = pola.po_line_id AND pol.line_type_id = polt.line_type_id AND pol.job_id = pj.job_id(+) AND pol.job_id = pa.job_id(+) AND pol.item_id = msi.inventory_item_id(+) AND fsp.inventory_organization_id = NVL (msi.organization_id, fsp.inventory_organization_id) AND fsp.org_id(+) = poh.org_id AND polc.lookup_code = NVL (pola.closed_code, 'OPEN') AND polc.lookup_type = 'DOCUMENT STATE' AND pol.po_header_id = pocr.document_header_id(+) AND pol.po_line_id = pocr.document_line_id(+) AND pocr.request_level(+) = 'LINE' AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_HEADER_ID = :1) ORDER BY LINE_NUM

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

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
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
via Oracle Community by 748660, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. . .
via Oracle Community by 795088, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.IllegalAccessError, msg=oracle/jdbc/driver/OracleCallableStatement
via Oracle Community by nv Teja, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT cesEO.EMPNO, cesEO.ENAME, cesEO.JOB, cesEO.MGR, cesEO.HIREDATE, cesEO.SAL, cesEO.COMM, cesEO.DEPTNO FROM EMP1 cesEO
via blogspot.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT cesEO.EMPNO, cesEO.ENAME, cesEO.JOB, cesEO.MGR, cesEO.HIREDATE, cesEO.SAL, cesEO.COMM, cesEO.DEPTNO FROM EMP1 cesEO
oracle.apps.fnd.framework.OAException: 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, pol.unit_meas_lookup_code, pol.quantity, pol.unit_price, pol.quantity * pol.unit_price total, poh.segment1 po_num, poh.currency_code, pol.item_id, fsp.inventory_organization_id, msi.segment1 segment1, pol.from_header_id, pola.closed_code, pola.cancel_flag, pola.closed_flag, pola.user_hold_flag, pol.attribute1, pol.attribute2, pol.attribute3, pol.attribute4, pol.attribute5, pol.attribute6, pol.attribute7, pol.attribute8, pol.attribute9, pol.attribute10, pol.attribute11, pol.attribute12, pol.attribute13, pol.attribute14, pol.attribute15, pol.attribute_category, pol.note_to_vendor, poh2.segment1 contract_num, pol.item_revision, pol.ussgl_transaction_code, NULL un_number, NULL hazard_class, pol.quantity_committed, pol.committed_amount, pol.expiration_date, NVL (pocr.new_price, pol.unit_price) new_price, NVL (pocr.new_supplier_part_number, pol.vendor_product_num ) new_supplier_part_number, pocr.request_status, 0 viewshipments, 'SItemType', 'PriceType', 'LineStatus', NVL (pos_get.get_item_config (pol.item_id, fsp.inventory_organization_id ), 'F' ) conf_flag, NULL ga_number, pocr.request_reason, DECODE (pocr.request_status, NULL, polc.displayed_field, fnd_message.get_string ('POS', 'POS_PENDING_CHANGE') ) line_display, pol.hazard_class_id, pol.un_number_id, NULL conf_details, 'REASON_TYPE', pol.job_id, pol.contractor_first_name, pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE', polt.order_type_lookup_code line_type, pj.NAME job_title, poh.global_agreement_flag, poh.type_lookup_code, 'ENTITY_TYPE', polt.line_type line_type_dsp, pa.job_description, NULL contractor_name, pol.amount line_amount, pol.supplier_ref_number, DECODE (pol.po_line_id, pol.line_num), 0, NULL, '@' ) archived_attachment FROM po_lines_archive_all pol, po_lines_all pola, po_headers_all poh, mtl_system_items_kfv msi, financials_system_params_all fsp, po_lookup_codes polc, po_change_requests pocr, po_line_types polt, per_jobs pj, po_job_associations pa, po_headers_all poh2 WHERE poh.po_header_id = pol.po_header_id AND poh.po_header_id = pola.po_header_id AND poh.po_header_id = poh.po_header_id + 0 AND pol.contract_id = poh2.po_header_id(+) AND pol.latest_external_flag = 'Y' AND pol.po_line_id = pola.po_line_id AND pol.line_type_id = polt.line_type_id AND pol.job_id = pj.job_id(+) AND pol.job_id = pa.job_id(+) AND pol.item_id = msi.inventory_item_id(+) AND fsp.inventory_organization_id = NVL (msi.organization_id, fsp.inventory_organization_id) AND fsp.org_id(+) = poh.org_id AND polc.lookup_code = NVL (pola.closed_code, 'OPEN') AND polc.lookup_type = 'DOCUMENT STATE' AND pol.po_header_id = pocr.document_header_id(+) AND pol.po_line_id = pocr.document_line_id(+) AND pocr.request_level(+) = 'LINE' AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_HEADER_ID = :1) ORDER BY LINE_NUM
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
at oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1136)
at oracle.apps.pos.changeorder.webui.PosViewPOCO.processRequest(PosViewPOCO.java:298)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

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, 1 year ago

Write tip

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