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

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, 1 month 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 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, 1 year ago
oracle.jbo.NoDefException: JBO-25002: Definition SupplierName of type Attribute not found
via Oracle Community by abhishek1981, 1 year ago
oracle.jbo.InvalidObjNameException: JBO-25005: Object name for type View Object is invalid
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.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 oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
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 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.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

Samebug visitor profile picture
Unknown user
Once, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.