oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id, OpportunityEO.description, OpportunityEO.status, OpportunityEO.sales_stage_id, OpportunityEO.total_amount, OpportunityEO.currency_code, OpportunityEO.decision_date, OpportunityEO.win_probability, OpportunityEO.close_reason, OpportunityEO.sales_methodology_id, OpportunityEO.channel_code, DECODE(OpportunityEO.sales_methodology_id, NULL, 'N','Y') AS sales_meth_flag, OpportunityEO.customer_id, hp.party_name, hp.party_type, OpportunityEO.attribute1, OpportunityEO.attribute2, OpportunityEO.attribute3, OpportunityEO.attribute4, OpportunityEO.attribute5, OpportunityEO.attribute6, OpportunityEO.attribute7, OpportunityEO.attribute8, OpportunityEO.attribute9, OpportunityEO.attribute10, OpportunityEO.attribute11, OpportunityEO.attribute12, OpportunityEO.attribute13, OpportunityEO.attribute14, OpportunityEO.attribute15, OpportunityEO.attribute_category, OpportunityContactEO.contact_party_id as relationship_party_id, OpportunityEO.source_promotion_id, amsc.arc_source_code_for, decode(amsc.arc_source_code_for , 'CAMP', (SELECT campaign_name FROM AMS_CAMPAIGNS_ALL_TL WHERE campaign_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'EVEH', (SELECT event_header_name FROM AMS_EVENT_HEADERS_ALL_TL WHERE event_header_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'EONE', (SELECT event_offer_name FROM AMS_EVENT_OFFERS_ALL_TL WHERE event_offer_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'EVEO', (SELECT event_offer_name FROM AMS_EVENT_OFFERS_ALL_TL WHERE event_offer_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'CSCH', (SELECT schedule_name FROM ams_campaign_schedules_tl WHERE schedule_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'OFFR', ( SELECT description FROM qp_list_headers_tl WHERE list_header_id = amsc.source_code_for_id AND language = USERENV('LANG')),null) as source_name, amsc.source_code, (SELECT SUM(opp_forecast_amount) FROM as_sales_credits ascs WHERE ascs.lead_id = OpportunityEO.lead_id AND ascs.credit_type_id = :1 ) as forecast_amount, '' as empty_string, DECODE ( 1, (SELECT 1 FROM as_sales_lead_opportunity aslo WHERE aslo.opportunity_id = OpportunityEO.lead_id GROUP BY opportunity_id HAVING count(1) > 1 ), 'ASNOpptyDetSrcNm', NVL((SELECT 'ASNOpptyDetSrcNmLnk' FROM as_sales_lead_opportunity aslo, as_sales_leads asl WHERE asl.source_system = 'SALES_CAMPAIGN' AND asl.source_promotion_id IS NOT NULL AND aslo.sales_lead_id = asl.sales_lead_id AND aslo.opportunity_id = OpportunityEO.lead_id AND ROWNUM = 1), 'ASNOpptyDetSrcNm')) as source_name_upd_flag, amsc.source_code_for_id, OpportunityEO.object_version_number, OpportunityContactEO.object_version_number as contact_object_version_number, OpportunityContactEO.lead_contact_id, DECODE(OpportunityEO.sales_stage_id, NULL, 'N','Y') AS sales_stage_flag, OpportunityEO.address_id, null as address , OpportunityEO.prm_referral_code, OpportunityEO.lead_number, OpportunityEO.vehicle_response_code, hp.email_address as Cust_Email, null as Cust_Formatted_Phone, hp.primary_phone_contact_pt_id as primary_phone_contact_pt_id, hl.location_id, hp.primary_phone_country_code, hp.primary_phone_area_code, hp.primary_phone_number, hp.primary_phone_extension FROM as_leads_all OpportunityEO, hz_parties hp, as_lead_contacts_all OpportunityContactEO, ams_source_codes amsc, hz_party_sites hps, hz_locations hl, fnd_territories_tl ftt WHERE OpportunityEO.customer_id = hp.party_id AND OpportunityEO.lead_id = OpportunityContactEO.lead_id(+) AND OpportunityEO.customer_id = OpportunityContactEO.customer_id(+) AND OpportunityContactEO.primary_contact_flag(+) = 'Y' AND OpportunityEO.source_promotion_id = amsc.source_code_id (+) AND OpportunityEO.address_id = hps.party_site_id(+) AND OpportunityEO.customer_id = hps.party_id (+) AND hps.location_id = hl.location_id (+) AND hl.country = ftt.territory_code (+) AND ftt.language (+) = USERENV('LANG') AND OpportunityEO.lead_id = :2 atoracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 887587, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id, OpportunityEO.description, OpportunityEO.status, OpportunityEO.sales_stage_id, OpportunityEO.total_amount
via Oracle Community by 755639, 1 year ago
java.lang.NumberFormatException: For input string: "null" + at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id, OpportunityEO.description, OpportunityEO.status, OpportunityEO.sales_stage_id, OpportunityEO.total_amount, OpportunityEO.currency_code, OpportunityEO.decision_date, OpportunityEO.win_probability, OpportunityEO.close_reason, OpportunityEO.sales_methodology_id, OpportunityEO.channel_code, DECODE(OpportunityEO.sales_methodology_id, NULL, 'N','Y') AS sales_meth_flag, OpportunityEO.customer_id, hp.party_name, hp.party_type, OpportunityEO.attribute1, OpportunityEO.attribute2, OpportunityEO.attribute3, OpportunityEO.attribute4, OpportunityEO.attribute5, OpportunityEO.attribute6, OpportunityEO.attribute7, OpportunityEO.attribute8, OpportunityEO.attribute9, OpportunityEO.attribute10, OpportunityEO.attribute11, OpportunityEO.attribute12, OpportunityEO.attribute13, OpportunityEO.attribute14, OpportunityEO.attribute15, OpportunityEO.attribute_category, OpportunityContactEO.contact_party_id as relationship_party_id, OpportunityEO.source_promotion_id, amsc.arc_source_code_for, decode(amsc.arc_source_code_for , 'CAMP', (SELECT campaign_name FROM AMS_CAMPAIGNS_ALL_TL WHERE campaign_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'EVEH', (SELECT event_header_name FROM AMS_EVENT_HEADERS_ALL_TL WHERE event_header_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'EONE', (SELECT event_offer_name FROM AMS_EVENT_OFFERS_ALL_TL WHERE event_offer_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'EVEO', (SELECT event_offer_name FROM AMS_EVENT_OFFERS_ALL_TL WHERE event_offer_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'CSCH', (SELECT schedule_name FROM ams_campaign_schedules_tl WHERE schedule_id = amsc.source_code_for_id AND language = USERENV('LANG')), 'OFFR', ( SELECT description FROM qp_list_headers_tl WHERE list_header_id = amsc.source_code_for_id AND language = USERENV('LANG')),null) as source_name, amsc.source_code, (SELECT SUM(opp_forecast_amount) FROM as_sales_credits ascs WHERE ascs.lead_id = OpportunityEO.lead_id AND ascs.credit_type_id = :1 ) as forecast_amount, '' as empty_string, DECODE ( 1, (SELECT 1 FROM as_sales_lead_opportunity aslo WHERE aslo.opportunity_id = OpportunityEO.lead_id GROUP BY opportunity_id HAVING count(1) > 1 ), 'ASNOpptyDetSrcNm', NVL((SELECT 'ASNOpptyDetSrcNmLnk' FROM as_sales_lead_opportunity aslo, as_sales_leads asl WHERE asl.source_system = 'SALES_CAMPAIGN' AND asl.source_promotion_id IS NOT NULL AND aslo.sales_lead_id = asl.sales_lead_id AND aslo.opportunity_id = OpportunityEO.lead_id AND ROWNUM = 1), 'ASNOpptyDetSrcNm')) as source_name_upd_flag, amsc.source_code_for_id, OpportunityEO.object_version_number, OpportunityContactEO.object_version_number as contact_object_version_number, OpportunityContactEO.lead_contact_id, DECODE(OpportunityEO.sales_stage_id, NULL, 'N','Y') AS sales_stage_flag, OpportunityEO.address_id, null as address , OpportunityEO.prm_referral_code, OpportunityEO.lead_number, OpportunityEO.vehicle_response_code, hp.email_address as Cust_Email, null as Cust_Formatted_Phone, hp.primary_phone_contact_pt_id as primary_phone_contact_pt_id, hl.location_id, hp.primary_phone_country_code, hp.primary_phone_area_code, hp.primary_phone_number, hp.primary_phone_extension FROM as_leads_all OpportunityEO, hz_parties hp, as_lead_contacts_all OpportunityContactEO, ams_source_codes amsc, hz_party_sites hps, hz_locations hl, fnd_territories_tl ftt WHERE OpportunityEO.customer_id = hp.party_id AND OpportunityEO.lead_id = OpportunityContactEO.lead_id(+) AND OpportunityEO.customer_id = OpportunityContactEO.customer_id(+) AND OpportunityContactEO.primary_contact_flag(+) = 'Y' AND OpportunityEO.source_promotion_id = amsc.source_code_id (+) AND OpportunityEO.address_id = hps.party_site_id(+) AND OpportunityEO.customer_id = hps.party_id (+) AND hps.location_id = hl.location_id (+) AND hl.country = ftt.territory_code (+) AND ftt.language (+) = USERENV('LANG') AND OpportunityEO.lead_id = :2 atoracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:612)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
at oracle.apps.fnd.framework.webui.beans.message.OAMessageLayoutBean.processRequest(OAMessageLayoutBean.java:393)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.