oracle.apps.fnd.framework.OAException

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.

  • EO Substitution
    via by 542163,
  • Help deleting VO substitution
    via by User285476,
    • 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

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    9 more bugmates