oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp from ap_invoice_lines_all lines, ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc, ap_holds_all holds where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code = lines.wfapproval_status and nvl(holds.line_location_id,-99) = nvl(lines.po_line_location_id,-99) and holds.invoice_id = lines.invoice_id and holds.hold_id = :0 and 1 = :1 union all select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp from ap_invoice_lines_all lines, ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc, ap_apinv_approvers aprv where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code = lines.wfapproval_status and lines.invoice_id = :2 and aprv.child_process_item_type = :3 and aprv.child_process_item_key = :4 and aprv.invoice_id = lines.invoice_id and aprv.line_number = lines.line_number and 1 = :5 union all select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp from ap_invoice_lines_all lines, ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code(+) = lines.wfapproval_status and lines.invoice_id = :6 and 1 = :7

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 web1083

  • via Oracle Community by NZ, 11 months ago
    , ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc, ap_holds_all holds where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code = lines.wfapproval_status and nvl
  • via Oracle Community by 802240, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID
  • via Oracle Community by user5425941, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp from ap_invoice_lines_all lines, ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc, ap_holds_all holds where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code = lines.wfapproval_status and nvl(holds.line_location_id,-99) = nvl(lines.po_line_location_id,-99) and holds.invoice_id = lines.invoice_id and holds.hold_id = :0 and 1 = :1 union all select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp from ap_invoice_lines_all lines, ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc, ap_apinv_approvers aprv where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code = lines.wfapproval_status and lines.invoice_id = :2 and aprv.child_process_item_type = :3 and aprv.child_process_item_key = :4 and aprv.invoice_id = lines.invoice_id and aprv.line_number = lines.line_number and 1 = :5 union all select lines.description, ph.segment1, lines.quantity_invoiced, lines.unit_meas_lookup_code, lines.unit_price, lines.amount, alc.displayed_field approval_status, to_char(lines.unit_price,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) unit_price_disp, to_char(lines.amount,FND_CURRENCY.SAFE_GET_FORMAT_MASK(ai.INVOICE_CURRENCY_CODE,25)) amount_disp from ap_invoice_lines_all lines, ap_invoices_all ai, po_headers_all ph, ap_lookup_codes alc where lines.po_header_id = ph.po_header_id(+) and lines.invoice_id = ai.invoice_id and alc.lookup_type = 'AP_WFAPPROVAL_STATUS' and alc.lookup_code(+) = lines.wfapproval_status and lines.invoice_id = :6 and 1 = :7 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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762) at oracle.apps.ap.invoice.request.negotiation.webui.NotifPGCO.processRequest(NotifPGCO.java:59) 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.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.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:1182) 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, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    10 more bugmates