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 | 4 years ago
  1. 0

    VO Not found error while VO extention

    Oracle Community | 4 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