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
  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 | 1 year 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