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 2725480, 1 year ago
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
via Oracle Community by 619461, 1 year ago
oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 129 with java object of type java.lang.String due to java.sql.SQLException.
via orafaq.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID
via Oracle Community by 594196, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID
via Oracle Community by Sunil Makam, 1 year ago
via hivmr.com by Unknown author, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.IllegalAccessError, msg=tried to access method oracle.xml.jaxb.JaxbListImpl.init(Ljava/lang/String;Ljava/lang/String;Ljava/util/ArrayList;Loracle/xml/jaxb/JaxbNode;I)V from class oracle.xml.jaxb.JaxbNode
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)