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

Oracle Community | NZ | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    VO Not found error while VO extention

    Oracle Community | 5 years ago | NZ
    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
  2. 0

    oracle.jbo.SQLStmtException:JBO-27122:SQLerror during statement preparation

    Oracle Community | 6 years ago | 837397
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT OPMTL.ORG_PAYMENT_METHOD_NAME , OPM.ORG_PAYMENT_METHOD_ID , OPM.CURRENCY_CODE , OPM.DEFINED_BALANCE_ID , PTTL.PAYMENT_TYPE_NAME , PT.TERRITORY_CODE , PT.CATEGORY , PT.PRE_VALIDATION_REQUIRED , OPM.EFFECTIVE_END_DATE , OPM.EFFECTIVE_START_DATE , USG.PAYROLL_ID , OPM.BUSINESS_GROUP_ID , PEA.ID_FLEX_NUM , FC.NAME CURRENCY_NAME, PAY_PPMV4_SS.GET_PPM_COUNTRY(OPM.ORG_PAYMENT_METHOD_ID,OPM.BUSINESS_GROUP_ID + 0) PPM_COUNTRY_CODE, PAY_PPMV4_SS.GET_PPM_COUNTRY(OPM.ORG_PAYMENT_METHOD_ID,OPM.BUSINESS_GROUP_ID + 0,'Y') TERRITORY_SHORT_NAME, PAY_PPMV4_SS.GET_BANK_FLEXCODE(OPM.ORG_PAYMENT_METHOD_ID,OPM.BUSINESS_GROUP_ID + 0) BANK_FLEX_CODE FROM PAY_ORG_PAYMENT_METHODS_F_TL OPMTL, PAY_PAYMENT_TYPES_TL PTTL, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_ORG_PAY_METHOD_USAGES_F USG, PAY_PAYMENT_TYPES PT, PAY_EXTERNAL_ACCOUNTS PEA, FND_SESSIONS FF , FND_CURRENCIES_VL FC WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID AND PTTL.LANGUAGE = USERENV('LANG') AND OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID AND OPMTL.LANGUAGE = USERENV('LANG') AND FF.SESSION_ID = USERENV('SESSIONID') AND FF.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND FF.EFFECTIVE_DATE BETWEEN USG.EFFECTIVE_START_DATE AND USG.EFFECTIVE_END_DATE AND USG.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID AND OPM.CURRENCY_CODE = FC.CURRENCY_CODE(+) AND OPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND USG.PAYROLL_ID = :1 AND OPM.BUSINESS_GROUP_ID + 0 = :2 AND :3 BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND OPM.DEFINED_BALANCE_ID IS NOT NULL) QRSLT WHERE (ORG_PAYMENT_METHOD_ID IN (837,977,133,279,274,417,297,226,324,271,183,390,396,429,217,144)
  3. 0

    JBO-27022: Failed to load value at index 93 with java object of type java.l

    Oracle Community | 5 years ago | 879472
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 93 with java object of type java.lang.String due to java.sql.SQLException.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Refresh picklist VO for message choice

    Oracle Community | 5 years ago | Dan Cretu
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set
  6. 0

    Not a statement exception error while compiling AMImpl file

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)
      6 frames
    3. oracle.apps.ap
      NotifPGCO.processRequest
      1. oracle.apps.ap.invoice.request.negotiation.webui.NotifPGCO.processRequest(NotifPGCO.java:59)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      13. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      14. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      17. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      18. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      19. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      22. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      23. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      24. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      25. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      27. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      28. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      29. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      30. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      33. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      34. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      35. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      36. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      37. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      38. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      39. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      40. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      41. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      42. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      43. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      43 frames