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

Solutions on the web1136

  • ), 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 901919, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT competence_id, step_value || ' - ' || name step_value FROM per_competence_levels_v) QRSLT WHERE (COMPETENCE_ID = :1 AND ( UPPER(STEP_VALUE) like UPPER(:2) AND (STEP_VALUE like :3 OR STEP_VALUE like :4 OR STEP_VALUE like :5 OR STEP_VALUE like :6)))
  • via Oracle Community by Asmirnov-Oracle, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    9 more bugmates