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 SUDHIR BHILAR, 1 year ago
), STEP_VALUE) END AS LEVEL_AND_NAME, PRL.RATING_LEVEL_ID, PC.COMPETENCE_ID, PRL.BEHAVIOURAL_INDICATOR, PRL.STEP_VALUE FROM PER_RATING_LEVELS_VL PRL, PER_COMPETENCES_VL PC WHERE PC.COMPETENCE_ID = :1 AND (PC.COMPETENCE_ID = PRL.COMPETENCE_ID OR PC.RATING_SCALE_ID = PRL.RATING_SCALE_ID)) QRSLT ORDER BY STEP_VALUE
via Oracle Community by Rajesh123, 5 months ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select lookup_code, meaning from fnd_lookup_values where lookup_type = :1 and language = :2 and (lookup_code = 'EXPENSE' OR (lookup_code = 'INVENTORY' AND :3 = 'Y') OR (lookup_code = 'SHOP FLOOR' AND :4 = 'Y')) order by meaning asc
via Oracle Community by User544872, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DISTINCT orc.action_code action_code, fl.meaning action_name FROM okc_rep_con_actions orc, fnd_lookups fl WHERE orc.status_code = :1 AND
via Oracle Community by T J, 4 weeks ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select * from hz_***** where attribute12 like NVL(:1,attribute12)
via Oracle Community by Ravi91349, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ppf.list_name full_name, hr_person_type_usage_info.get_user_person_type(ppf.effective_end_date, ppf.person_id) person_type, Decode
via Oracle Community by user573991, 2 years ago
oracle.jbo.NoDefException: JBO-25002: Definition SupplierName of type Attribute not found
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT CASE WHEN UPPER(PRL.NAME) LIKE UPPER('LEVEL%') THEN NVL(PRL.NAME,STEP_VALUE) ELSE NVL2(PRL.NAME, (STEP_VALUE || '-' || PRL.NAME), STEP_VALUE) END AS LEVEL_AND_NAME, PRL.RATING_LEVEL_ID, PC.COMPETENCE_ID, PRL.BEHAVIOURAL_INDICATOR, PRL.STEP_VALUE FROM PER_RATING_LEVELS_VL PRL, PER_COMPETENCES_VL PC WHERE PC.COMPETENCE_ID = :1 AND (PC.COMPETENCE_ID = PRL.COMPETENCE_ID OR PC.RATING_SCALE_ID = PRL.RATING_SCALE_ID)) QRSLT ORDER BY STEP_VALUE	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3483)	at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237)	at _pages.__oa._jspService(__oa.java:252)	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.ServletStubImpl.execute(ServletStubImpl.java:184)	at weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)	at weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)	at weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)	at _pages.__oa._jspService(__oa.java:246)	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:315)	at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)	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:139)	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)