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

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1357

  • via Unknown by 745071,
  • Stack trace

    • 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 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.aso.print.webui.MainCO.processRequest(MainCO.java:180) 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.OAHeaderBean.processRequest(OAHeaderBean.java:391) 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 visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    10 more bugmates