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

Oracle Community | Dan Cretu | 5 years ago
  1. 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
  2. 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
  3. 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)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.
  6. 0

    OAF

    Oracle Community | 5 years ago | 745071
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DECODE(ASO_QUOTES.RESOURCE_ID, null, sales.name, sales1.name) sales_rep_name, aso_quotes.quote_name, aso_quotes.contract_id, aso_quotes.quote_number||decode(aso_quotes.quote_version,NULL,'',' - ') || aso_quotes.quote_version quote_name_version, to_char(aso_quotes.quote_expiration_date, nvl(FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'), 'DD-MON-RRRR')) quote_expiration_date, TO_NUMBER(TO_CHAR(aso_quotes.quote_expiration_date,'J')) - TO_NUMBER(TO_CHAR(Sysdate,'J')) duration, I_HEADER_CONTACT_PARTY.PARTY_NAME sold_to_contact_name, I_CUST_PARTIES.party_name customer_name, I_PHONE.PHONE_AREA_CODE || DECODE(I_PHONE.PHONE_AREA_CODE , NULL, '',' ' ) || I_PHONE.PHONE_NUMBER full_phone_number, I_INVOICE_REL_PARTY.PARTY_NAME invoice_to_contact_name, I_ACCTS_INV_PARTY.PARTY_NAME invoice_to_cust_party_name, I_INVOICE_LOCATIONS.ADDRESS1 invoice_to_address1, I_INVOICE_LOCATIONS.ADDRESS2 invoice_to_address2, I_INVOICE_LOCATIONS.ADDRESS3 invoice_to_address3, I_INVOICE_LOCATIONS.ADDRESS4 invoice_to_address4, decode(I_INVOICE_LOCATIONS.city, null,'',I_INVOICE_LOCATIONS.city || decode(I_INVOICE_LOCATIONS.county,null,'',',' || I_INVOICE_LOCATIONS.county)) invoice_to_city, I_INVOICE_LOCATIONS.state || decode(I_INVOICE_LOCATIONS.postal_code, null,'',' '|| I_INVOICE_LOCATIONS.postal_code || decode(I_INVOICE_LOCATIONS.province,null,'',',' ||I_INVOICE_LOCATIONS.province )) invoice_to_county, I_INVOICE_LOCATIONS.country invoice_to_country, aso_quotes.currency_code Currency_Code, (select distinct ppf.email_address from per_people_f ppf, JTF_RS_SALESREPS jrs where jrs.resource_id = aso_quotes.resource_id and jrs.PERSON_ID = ppf.person_id and ppf.person_type_id = 3 ) Sales_Rep_Email, aso_quotes.quote_header_id, oav.name||decode(oav.agreement_num,NULL,'',',')||oav.agreement_num||decode(oav.agreement_num,NULL,'',',')||oav.revision Agreement_name, oav.name||oav.agreement_num||oav.revision Agreement_check, to_char(oav.revision_date, nvl(FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'), 'DD-MON-RRRR')) revision_date, (select payment_term_name FROM aso_payments_v WHERE quote_line_id is null and quote_header_id = aso_quotes.quote_header_id) payment_terms, to_char(sysdate, nvl(FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'), 'DD-MON-RRRR')) curr_date, aso_quotes.total_list_price total_list_price, aso_quotes.total_adjusted_amount total_adjusted_amount, (aso_quotes.total_list_price + aso_quotes.total_adjusted_amount) total_net_price, aso_quotes.total_shipping_charge charges_total, aso_quotes.total_tax taxes_total, aso_quotes.total_quote_price total_quote_price, (select cust_po_number FROM aso_payments WHERE quote_line_id is null and quote_header_id = aso_quotes.quote_header_id ) cust_po_number, (select fct.name from fnd_currencies_tl fct where aso_quotes.currency_code = fct.currency_code and fct.language = userenv('lang')) Currency_Name, (select fcurr.symbol from fnd_currencies fcurr where aso_quotes.currency_code = fcurr.currency_code) Currency_Symbol, (Select meaning From oe_lookups Where lookup_type = 'FREIGHT_TERMS' And lookup_code = (select aship.freight_terms_code from aso_shipments aship where aship.quote_header_id = aso_quotes.quote_header_id and aship.quote_line_id is null)) Freight_Terms, (Select fl.meaning From fnd_lookup_values fl where fl.lookup_type = 'SHIP_METHOD' And fl.lookup_code = (select aship.ship_method_code from aso_shipments aship where aship.quote_header_id = aso_quotes.quote_header_id and aship.quote_line_id is null) And fl.language = userenv('LANG')) shipping_method , aso_quotes.org_id , aso_quotes.quote_number , aso_quotes.Quote_version VersionNumber, I_ACCTS.ACCOUNT_NUMBER CustomerNumber, oav.agreement_num Agreement_Number, aso_quotes.minisite_id minisite_id, (select imt.msite_name from ibe_msites_tl imt where imt.msite_id = aso_quotes.minisite_id and imt.language = userenv('LANG')) msite_name, (select asl.meaning from oe_lookups asl, aso_shipments ash where asl.lookup_type = 'SHIPMENT_PRIORITY' and asl.lookup_code = ash.shipment_priority_code and ash.quote_header_id = aso_quotes.quote_header_id) shipment_priority_name ,(select OE_SYS_PARAMETERS.VALUE('INSTALLMENT_OPTIONS',aso_quotes.org_id) from dual) enable_pay_now ,(select NVL(TO_CHAR(pp.phone_number), ' ') from hr.per_phones pp, JTF_rs_srp_vl jrsv ,aso_quote_headers_all aqh where pp.parent_id = jrsv.person_id and jrsv.resource_id = aqh.resource_id AND pp.phone_type = 'W1' and aqh.quote_header_id = aso_quotes.quote_header_id) work_telephone , (select NVL(TO_CHAR(pp.phone_number),' ') from hr.per_phones pp, JTF_rs_srp_vl jrsv, aso_quote_headers_all aqh where pp.parent_id = jrsv.person_id and jrsv.resource_id = aqh.resource_id AND pp.phone_type = 'M' and aqh.quote_header_id = aso_quotes.quote_header_id) cell_number, (select NVL(TO_CHAR(pp.phone_number), ' ') from hr.per_phones pp, JTF_rs_srp_vl jrsv, aso_quote_headers_all aqh where pp.parent_id = jrsv.person_id and jrsv.resource_id = aqh.resource_id AND pp.phone_type = 'WF' and aqh.quote_header_id = aso_quotes.quote_header_id) fax_number ,(select country_code || '-' || area_code || '-' || phone_number from ar_phones_v apv where apv.owner_table_id = aso_quotes.invoice_to_contact_party_id and phone_type = 'GEN' and owner_table_name = 'HZ_PARTIES' and status = 'A' and rownum = 1 and primary_flag = 'Y') bill_to_phone_number ,(select country_code || '-' || area_code || '-' || phone_number from ar_phones_v apv where apv.owner_table_id = aso_quotes.invoice_to_contact_party_id and phone_type = 'MOBILE' and status = 'A' and owner_table_name = 'HZ_PARTIES' and rownum = 1) bill_to_cell_number, (select country_code || '-' || area_code || '-' || phone_number from ar_phones_v apv where apv.owner_table_id = aso_quotes.invoice_to_contact_party_id and phone_type = 'FAX' and status = 'A' and owner_table_name = 'HZ_PARTIES' and rownum = 1) bill_to_fax_number, (select email_address from ar_phones_v apv where apv.owner_table_id = aso_quotes.invoice_to_contact_party_id and phone_type = 'EMAIL' and status = 'A' and owner_table_name = 'HZ_PARTIES' and rownum = 1) bill_to_email_address, (select apv.country_code || '-' || apv.area_code || '-' || apv.phone_number from ar_phones_v apv, aso_shipments asos where aso_quotes.quote_header_id = asos.quote_header_id and asos.quote_line_id is null and apv.OWNER_TABLE_ID = get_ship_to_party_id(aso_quotes.quote_header_id) and apv.owner_table_name = 'HZ_PARTIES' and apv.phone_type = 'GEN' and status = 'A' and rownum = 1 and primary_flag = 'Y') ship_to_phone_number, (select apv.country_code || '-' || apv.area_code || '-' || apv.phone_number from ar_phones_v apv, aso_shipments asos where aso_quotes.quote_header_id = asos.quote_header_id and asos.quote_line_id is null and apv.OWNER_TABLE_ID = get_ship_to_party_id(aso_quotes.quote_header_id) and apv.owner_table_name = 'HZ_PARTIES' and apv.phone_type = 'MOBILE' and status = 'A' and rownum = 1) ship_to_cell_phone, (select apv.country_code || '-' || apv.area_code || '-' || apv.phone_number from ar_phones_v apv, aso_shipments asos where aso_quotes.quote_header_id = asos.quote_header_id and asos.quote_line_id is null and apv.OWNER_TABLE_ID = get_ship_to_party_id(aso_quotes.quote_header_id) and apv.owner_table_name = 'HZ_PARTIES' and apv.phone_type = 'FAX' and status = 'A' and rownum = 1) ship_to_fax_number, (select apv.email_address from ar_phones_v apv, aso_shipments asos where aso_quotes.quote_header_id = asos.quote_header_id and asos.quote_line_id is null and apv.OWNER_TABLE_ID = get_ship_to_party_id(aso_quotes.quote_header_id) and apv.owner_table_name = 'HZ_PARTIES' and apv.phone_type = 'EMAIL' and status = 'A' and rownum = 1) ship_to_email_address from hz_CONTACT_POINTS I_PHONE , HZ_RELATIONSHIPS I_HEADER_CONTACT_REL, HZ_PARTIES I_HEADER_CONTACT_PARTY, aso_pvt_quote_headers_v ASO_QUOTES, HZ_RELATIONSHIPS I_INVOICE_REL, HZ_PARTIES I_INVOICE_REL_PARTY, HZ_PARTY_sites I_INVOICE_PARTY_SITES, HZ_LOCATIONS I_INVOICE_LOCATIONS, HZ_PARTIES I_CUST_PARTIES, HZ_CUST_ACCOUNTS I_ACCTS, HZ_CUST_ACCOUNTS I_ACCTS_INV, HZ_PARTIES I_ACCTS_INV_PARTY, JTF_RS_SALESREPS_MO_V SALES, JTF_RS_SALESREPS_MO_V SALES1, FND_TERRITORIES_VL I_TERRITORIES, oe_agreements_vl oav where ASO_QUOTES.PARTY_ID = I_HEADER_CONTACT_REL.PARTY_ID(+) AND I_HEADER_CONTACT_REL.SUBJECT_ID = I_HEADER_CONTACT_PARTY.PARTY_ID(+) AND I_HEADER_CONTACT_REL.SUBJECT_TYPE(+) = 'PERSON' AND I_HEADER_CONTACT_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES' and i_header_contact_rel.object_id(+) = aso_quotes.party_id AND ASO_QUOTES.INVOICE_TO_PARTY_SITE_ID = I_INVOICE_PARTY_SITES.PARTY_SITE_ID (+) AND I_INVOICE_PARTY_SITES.LOCATION_ID = I_INVOICE_LOCATIONS.LOCATION_ID(+) AND I_INVOICE_LOCATIONS.country = I_TERRITORIES.territory_code(+) AND ASO_QUOTES.INVOICE_TO_PARTY_ID = I_INVOICE_REL.PARTY_ID(+) AND I_INVOICE_REL.SUBJECT_ID = I_INVOICE_REL_PARTY.PARTY_ID(+) AND I_INVOICE_REL.SUBJECT_TYPE(+) = 'PERSON' AND I_INVOICE_REL.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES' AND i_invoice_rel.object_id (+) = aso_quotes.invoice_to_cust_party_id AND ASO_QUOTES.ORG_ID = SALES.ORG_ID(+) AND ASO_QUOTES.EMPLOYEE_PERSON_ID = SALES.PERSON_ID (+) AND ASO_QUOTES.ORG_ID = SALES1.ORG_ID (+) AND ASO_QUOTES.RESOURCE_ID = SALES1.RESOURCE_ID (+) AND ASO_QUOTES.CUST_ACCOUNT_ID =I_ACCTS.CUST_ACCOUNT_ID(+) AND ASO_QUOTES.PARTY_ID = I_CUST_PARTIES.PARTY_ID AND ASO_QUOTES.INVOICE_TO_CUST_ACCOUNT_ID = I_ACCTS_INV.CUST_ACCOUNT_ID(+) AND ASO_QUOTES.party_id = I_ACCTS_INV_PARTY.PARTY_ID(+) And Aso_Quotes.Phone_Id = I_Phone.Contact_Point_Id(+) And Oav.Agreement_Id(+) = Aso_Quotes.Contract_Id AND aso_quotes.quote_header_id =:DocumentId

    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.InvalidParamException: JBO-25006: Invalid parameter value 2 for rangeIndex passed to method ViewRowSetIteratorImpl.insertRowAtRangeIndex. Explanation: index beyond end of row set

      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.pos
      ViewPOControlsCO.processRequest
      1. oracle.apps.pos.changeorder.webui.ViewPOControlsCO.processRequest(ViewPOControlsCO.java:319)
      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.nav.OAPageButtonBarBean.processRequest(OAPageButtonBarBean.java:351)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:989)
      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.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)
      9. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      14. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      19. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      20. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      21. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      22. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      23. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      23 frames