oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • WhO column error in OAF page
    via by user9952568,
  • Not able to upload RTF files
    via by Diwakar Dhake,
  • Error while creating a customer
    via by 747863,
    • 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 at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source) 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) at oracle.apps.xxfe.f486.asn.opportunity.webui.ASNOpptyLstCOEx.processFormRequest(ASNOpptyLstCOEx.java:134) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854) at oracle.apps.fnd.framework.webui.OATableHelper.processFormRequest(OATableHelper.java:460) at oracle.apps.fnd.framework.webui.beans.table.OATableBean.processFormRequest(OATableBean.java:1058) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormRequest(OAHeaderBean.java:410) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.OAQueryHelper.processFormRequest(OAQueryHelper.java:1035) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.beans.OAFlexibleContentBean.processFormRequest(OAFlexibleContentBean.java:372) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.beans.layout.OAFlexibleLayoutBean.processFormRequest(OAFlexibleLayoutBean.java:376) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1319) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1032) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:887) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:407) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3172) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1927) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:567) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:455) at _pages.__oa._jspService(__oa.java:233) at weblogic.servlet.jsp.JspBase.service(JspBase.java:34) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    10 more bugmates