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

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)