oracle.apps.fnd.framework.OAException: java.lang.NumberFormatException: For input string: "null"

Oracle Community | user15639 | 6 years ago
  1. 0

    unable to launch jinitiator after ATG RUP7

    Oracle Community | 6 years ago | user15639
    oracle.apps.fnd.framework.OAException: java.lang.NumberFormatException: For input string: "null"
  2. 0

    Workflow erro

    Oracle Community | 8 years ago | 688974
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException<br>
  3. 0

    NullPointerException and cannot be cast when extended CO!

    Oracle Community | 7 years ago | 722468
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.apps.fnd.framework.webui.beans.layout.OAQueryBean cannot be cast to oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBO-27122: SQL error during statement preparation

    Oracle Community | 4 years ago | 887587
    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)
  6. 0

    does not exist favicon.ico and splash.gif

    Oracle Community | 8 years ago | SG2
    oracle.apps.fnd.framework.OAException: java.lang.NumberFormatException: For input string: "null"

    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

      java.lang.NumberFormatException: For input string: "null"

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAWebBeanContainerHelper.processRequest
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)
      3. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)
      8 frames