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, 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_LINE_ID in (select PO_LINE_ID from po_line_locations_all where PO_HEADER_ID = :1 and PO_RELEASE_ID = :2)) ORDER BY LINE_NUM

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 web1256

  • via Oracle Community by 884536, 11 months ago
    = 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_LINE_ID in (select PO_LINE_ID from po_line_locations_all where PO_HEADER_ID = :1 and PO_RELEASE_ID = :2)) ORDER BY LINE_NUM
  • via Oracle Community by 884536, 11 months ago
    , 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
  • via Oracle Community by 624291, 1 year ago
    = PLL.PO_HEADER_ID AND POLC.LOOKUP_CODE = NVL(PLL.CLOSED_CODE, 'OPEN') AND POLC.LOOKUP_TYPE = 'DOCUMENT STATE' AND PLL.PO_HEADER_ID = POCR.DOCUMENT_HEADER_ID AND PLL.LINE_LOCATION_ID = POCR.PARENT_LINE_LOCATION_ID AND POCR.CHANGE_ACTIVE_FLAG = 'Y' AND POCR.REQUEST_LEVEL = 'SHIPMENT') QRSLT WHERE (PO_LINE_ID = :1)
  • Stack trace

    • 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, 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_LINE_ID in (select PO_LINE_ID from po_line_locations_all where PO_HEADER_ID = :1 and PO_RELEASE_ID = :2)) 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:300) 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)

    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, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates