oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 3000: Invalid value(s) passed for arguments. ITEMTYPE=NULL ITEMKEY=NULL ANAME=PROCESS_NAME ORA-06512: at "APPS.WF_ENGINE", line 1663 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)

Oracle Community | 563297 | 7 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Running Qualifications Page Locally ends in Error

    Oracle Community | 7 years ago | 563297
    oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 3000: Invalid value(s) passed for arguments. ITEMTYPE=NULL ITEMKEY=NULL ANAME=PROCESS_NAME ORA-06512: at "APPS.WF_ENGINE", line 1663 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
  2. 0

    none of the links or buttons do not works after change the name of the page

    Oracle Community | 8 years ago | 668089
    oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 3000: Invalid value(s) passed for arguments. ITEMTYPE=NULL ITEMKEY=NULL ANAME=HR_FIRST_ACTIVITY_ID ORA-06512: at "APPS.WF_ENGINE", line 1664 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
  3. 0

    ClassCastException while creating content container

    Oracle Community | 8 years ago | 595537
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException * at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    11i Selfservice page Error

    Oracle Community | 6 years ago | 755639
    oracle.apps.fnd.framework.OAException: java.lang.NumberFormatException: For input string: "null" + at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
  6. 0

    JBO-27122: SQL error during statement preparation

    Oracle Community | 5 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)

    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.sql.SQLException: ORA-20002: 3000: Invalid value(s) passed for arguments. ITEMTYPE=NULL ITEMKEY=NULL ANAME=PROCESS_NAME ORA-06512: at "APPS.WF_ENGINE", line 1663 ORA-06512: at line 1at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)

      at oracle.apps.fnd.framework.webui.OANavigation.getItemAttrText()
    2. oracle.apps.fnd
      OANavigation.getItemAttrText
      1. oracle.apps.fnd.framework.webui.OANavigation.getItemAttrText(Unknown Source)
      1 frame
    3. oracle.apps.per
      QuaOverviewPageCO.processRequest
      1. oracle.apps.per.selfservice.workflowservice.server.WFUtility.getProcessName(WFUtility.java:1421)
      2. oracle.apps.per.selfservice.qualifications.webui.OverviewPageCO.processRequest(OverviewPageCO.java:117)
      3. oracle.apps.per.selfservice.qualifications.webui.QuaOverviewPageCO.processRequest(QuaOverviewPageCO.java:66)
      3 frames
    4. oracle.apps.fnd
      OAWebBeanHelper.processRequest
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)
      6 frames