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

Oracle Community | SUDHIR BHILAR | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.

    Oracle Community | 2 years ago | SUDHIR BHILAR
    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
  2. 0

    java.lang.ArrayIndexOutOfBoundsException: 3      at oracle.sql.DATE.toTimestamp(DATE.java:338)

    Oracle Community | 2 years ago | 895773
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 3
  3. 0

    IAsset Error Page When Submit Create Transfer Request

    Oracle Community | 1 year ago | Jenna_C
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = IADTL18005; APPLICATION_MODULE = oracle.apps.ia.requests.transfer.server.RequestRootAM;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    VO Extension issue in Standard Page inR12.2.4 instance

    Oracle Community | 1 year ago | 2899825
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition CategoryCode of type Attribute not found in HzPuiDQMSrchResultsVO
  6. 0

    java.sql.SQLException: Missing IN or OUT parameter at index:: 1 - OA Framework

    developer-works.com | 2 years ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT e.template_id, p.template_name FROM gecm_otst_enable_templates e, gecm_otst_prompts_tl p WHERE e.template_id = p.template_id AND org_id = :1 AND LANGUAGE = :2 UNION SELECT t.template_id, p.template_name FROM gecm_otst_prompts_tl p, gecm_otst_addr_templates t WHERE t.template_id = p.template_id AND t.org_id = -1 AND p.LANGUAGE = :2 AND NOT EXISTS(SELECT e.template_id, p.template_name FROM gecm_otst_enable_templates e, gecm_otst_prompts_tl p WHERE e.template_id = p.template_id AND org_id = :1 AND LANGUAGE = :2)

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3483)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237)
      4 frames
    3. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:252)
      1 frame
    4. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    5. Atmosphere weblogic
      RequestDispatcherImpl.forward
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
      5. weblogic.servlet.internal.RequestDispatcherImpl.invokeServlet(RequestDispatcherImpl.java:526)
      6. weblogic.servlet.internal.RequestDispatcherImpl.forward(RequestDispatcherImpl.java:253)
      6 frames
    6. weblogic.servlet.jsp
      PageContextImpl.forward
      1. weblogic.servlet.jsp.PageContextImpl.forward(PageContextImpl.java:159)
      1 frame
    7. _pages
      __oa._jspService
      1. _pages.__oa._jspService(__oa.java:246)
      1 frame
    8. weblogic.servlet.jsp
      JspBase.service
      1. weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
      1 frame
    9. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      2. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      3. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
      4. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      5. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      5 frames
    10. oracle.apps.fnd
      WLFilter.doFilter
      1. oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:213)
      1 frame
    11. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    12. oracle.apps.jtf
      JTFWrapperFilter.doFilter
      1. oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:141)
      1 frame
    13. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    14. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source)
      1 frame
    15. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    16. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:432)
      1 frame
    17. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    18. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      1 frame
    19. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    20. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      5 frames
    21. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      1 frame
    22. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
      1 frame
    23. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)
      3 frames
    24. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    25. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    26. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
      2. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
      3. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
      3 frames
    27. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      2 frames