Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. ASNOpptyLstCO.executeOpptyQuery() has thrown an OAException
    Unsorted
    0
    0
    0
  2. OAApplicationModuleImpl.invokeMethod() has thrown an OAException
    Unsorted
    0
    0
    0

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id , OpportunityEO.last_update_date as LastUpdateDate, OpportunityEO.creation_date , OpportunityEO.lead_number, OpportunityEO.customer_id, NVL(OpportunityEO.TOTAL_AMOUNT,0) as TotalAmount, OpportunityEO.Decision_Date, OpportunityEO.win_probability , OpportunityEO.description as Description, OpportunityEO.Currency_Code, OpportunityEO.Source_Promotion_Id , OpportunityEO.OWNER_SALESFORCE_ID, OpportunityEO.TOTAL_REVENUE_OPP_FORECAST_AMT , null as VehicleResponseCode, ast.meaning as OpptyStatusName, null as CurrencyName, null as SalesStageName, hp.party_name as PartyName, null as CustomerCategory, null as PersonId, null as ContactName, null as PersonFirstName, null as PersonLastName, null as PersonMiddleName, null as Salutation, null as EmailAddress, null as JobTitle, null as PhoneCountryCode, null as PhoneAreaCode, null as PhoneNumber , null as PhoneExtension , null as PhoneLineType , to_number(null) as ContactPointId ,null as FormattedPhone, OpportunityEO.attribute1 as State , hp.attribute4 as City, (case WHEN length(OpportunityEO.attribute13) != 19 THEN null ELSE fnd_date.canonical_to_date(OpportunityEO.attribute13) END) as Country, (case WHEN length(OpportunityEO.attribute14) != 19 THEN null ELSE fnd_date.canonical_to_date(OpportunityEO.attribute14) END) as Province, null as PostalCode, to_number(null) as ContactLocationId,null as Address, null as SourceName, jrt.resource_name as ResourceName, null as SalesChannel, null as RelationShipId, null as PrimaryContactPartyId, null as CustState, null as CustCity, null as CustCountry, null as CustProvince, null as CustPostalCode, to_number(null) as CustomerLocationId, null as CustAddress, null as OpptyUpdatedBy, null as OpptyCreatedBy, null as MethodologyNm, null as CloseReason, null as AssignmentStatusNm, OpportunityEO.PRM_Referral_Code as ReferralCode , null as PrimaryPhoneCountryCode, null as PrimaryPhoneAreaCode, null as PrimaryPhoneNumber , null as PrimaryPhoneExtension , null as PrimaryPhoneLineType , to_number(null) as CustomerContactPointId ,null as CustFormattedPhone, null as CustEmailAddress, null as ConvAmt, null as ConvFrcstAmt, null as SourceCode FROM as_leads_all OpportunityEO ,( SELECT /*+ no_merge */ distinct aaa.lead_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NULL AND aaa.lead_id IS NOT NULL AND aaa.open_flag = 'Y' AND aaa.salesforce_id = :0) secu , as_statuses_tl ast , as_lead_contacts_all alca, hz_parties hcp ,fnd_territories_tl ftt ,hz_parties hp , jtf_rs_resource_extns_tl jrt WHERE OpportunityEO.lead_id = secu.lead_id AND OpportunityEO.status = ast.status_code AND ast.language = USERENV('LANG') AND OpportunityEO.lead_id = alca.lead_id AND OpportunityEO.customer_id = alca.customer_id AND alca.primary_contact_flag = 'Y' AND alca.contact_party_id = hcp.party_id(+) AND hcp.country = ftt.territory_code AND ftt.language = USERENV('LANG') AND OpportunityEO.customer_id = hp.party_id AND OpportunityEO.owner_salesforce_id = jrt.resource_id AND jrt.language = USERENV('LANG') ORDER BY LastUpdateDate DESC
4 matching frames hidden
    at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:733)
    at oracle.apps.asn.opportunity.webui.ASNOpptyLstCO.executeOpptyQuery(Unknown Source)
    at oracle.apps.xxfe.f486.asn.opportunity.webui.ASNOpptyLstCOEx.executeOpptyQuery(ASNOpptyLstCOEx.java:335)
    at oracle.apps.asn.opportunity.webui.ASNOpptyLstCO.processFormRequest(Unknown Source)
87 frames hidden

External results for this pattern (2)

  1. 533926via Oracle Community4 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id , OpportunityEO.last_update_date , OpportunityEO.creation_date , OpportunityEO.lead_number, OpportunityEO.customer_id, OpportunityEO.TOTAL_AMOUNT, OpportunityEO.Decision_Date, OpportunityEO.win_probability , SUBSTRB(OpportunityEO.description, 1,240) as Description, OpportunityEO.Currency_Code, OpportunityEO.Source_Promotion_Id , OpportunityEO.OWNER_SALESFORCE_ID, OpportunityEO.TOTAL_REVENUE_OPP_FORECAST_AMT , null as VehicleResponseCode, ast.meaning as OpptyStatusName, fnt.name as CurrencyName, asst.name as SalesStageName, hp.party_name as PartyName, null as CustomerCategory, null as PersonId, null as ContactName, null as PersonFirstName, null as PersonLastName, null as PersonMiddleName, null as Salutation, null as EmailAddress, null as JobTitle, null as FormattedPhone, null as State, null as City, null as Country, null as Province, null as PostalCode, null as Address, null as SourceName, null as ResourceName, null as SalesChannel, null as RelationShipId, null as PrimaryContactPartyId, null as CustState, null as CustCity, null as CustCountry, null as CustProvince, null as CustPostalCode, null as CustAddress, null as OpptyUpdatedBy, null as OpptyCreatedBy, null as MethodologyNm, null as CloseReason, null as AssignmentStatusNm, OpportunityEO.PRM_Referral_Code as ReferralCode FROM as_leads_all OpportunityEO , as_statuses_b asb , as_statuses_tl ast , as_sales_stages_all_tl asst , fnd_currencies_tl fnt ,hz_parties hp WHERE OpportunityEO.status = asb.status_code AND OpportunityEO.status = ast.status_code AND ast.language = USERENV('LANG') AND OpportunityEO.sales_stage_id = asst.sales_stage_id(+) AND asst.language (+) = USERENV ('LANG') AND OpportunityEO.currency_code = fnt.currency_code AND fnt.language = USERENV('LANG') AND OpportunityEO.customer_id = hp.party_id and asb.opp_open_status_flag = :0 AND OpportunityEO.owner_salesforce_id = :1 Order by OpportunityEO.last_update_date DESC
    Show stack trace
  2. 2725480via Oracle Community2 years ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id , OpportunityEO.last_update_date as LastUpdateDate, OpportunityEO.creation_date , OpportunityEO.lead_number, OpportunityEO.customer_id, NVL(OpportunityEO.TOTAL_AMOUNT,0) as TotalAmount, OpportunityEO.Decision_Date, OpportunityEO.win_probability , OpportunityEO.description as Description, OpportunityEO.Currency_Code, OpportunityEO.Source_Promotion_Id , OpportunityEO.OWNER_SALESFORCE_ID, OpportunityEO.TOTAL_REVENUE_OPP_FORECAST_AMT , null as VehicleResponseCode, ast.meaning as OpptyStatusName, null as CurrencyName, null as SalesStageName, hp.party_name as PartyName, null as CustomerCategory, null as PersonId, null as ContactName, null as PersonFirstName, null as PersonLastName, null as PersonMiddleName, null as Salutation, null as EmailAddress, null as JobTitle, null as PhoneCountryCode, null as PhoneAreaCode, null as PhoneNumber , null as PhoneExtension , null as PhoneLineType , to_number(null) as ContactPointId ,null as FormattedPhone, OpportunityEO.attribute1 as State , hp.attribute4 as City, (case WHEN length(OpportunityEO.attribute13) != 19 THEN null ELSE fnd_date.canonical_to_date(OpportunityEO.attribute13) END) as Country, (case WHEN length(OpportunityEO.attribute14) != 19 THEN null ELSE fnd_date.canonical_to_date(OpportunityEO.attribute14) END) as Province, null as PostalCode, to_number(null) as ContactLocationId,null as Address, null as SourceName, jrt.resource_name as ResourceName, null as SalesChannel, null as RelationShipId, null as PrimaryContactPartyId, null as CustState, null as CustCity, null as CustCountry, null as CustProvince, null as CustPostalCode, to_number(null) as CustomerLocationId, null as CustAddress, null as OpptyUpdatedBy, null as OpptyCreatedBy, null as MethodologyNm, null as CloseReason, null as AssignmentStatusNm, OpportunityEO.PRM_Referral_Code as ReferralCode , null as PrimaryPhoneCountryCode, null as PrimaryPhoneAreaCode, null as PrimaryPhoneNumber , null as PrimaryPhoneExtension , null as PrimaryPhoneLineType , to_number(null) as CustomerContactPointId ,null as CustFormattedPhone, null as CustEmailAddress, null as ConvAmt, null as ConvFrcstAmt, null as SourceCode FROM as_leads_all OpportunityEO ,( SELECT /*+ no_merge */ distinct aaa.lead_id FROM as_accesses_all aaa WHERE aaa.sales_lead_id IS NULL AND aaa.lead_id IS NOT NULL AND aaa.open_flag = 'Y' AND aaa.salesforce_id = :0) secu , as_statuses_tl ast , as_lead_contacts_all alca, hz_parties hcp ,fnd_territories_tl ftt ,hz_parties hp , jtf_rs_resource_extns_tl jrt WHERE OpportunityEO.lead_id = secu.lead_id AND OpportunityEO.status = ast.status_code AND ast.language = USERENV('LANG') AND OpportunityEO.lead_id = alca.lead_id AND OpportunityEO.customer_id = alca.customer_id AND alca.primary_contact_flag = 'Y' AND alca.contact_party_id = hcp.party_id(+) AND hcp.country = ftt.territory_code AND ftt.language = USERENV('LANG') AND OpportunityEO.customer_id = hp.party_id AND OpportunityEO.owner_salesforce_id = jrt.resource_id AND jrt.language = USERENV('LANG') ORDER BY LastUpdateDate DESC
    Show stack trace