javax.faces.el.EvaluationException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT part.PARTICIPANT_CATEGORY_ID, part.PARTICIPANT_EMAIL, part.PARTICIPANT_NAME, part.REVIEW_ID, part.REVIEW_PARTICIPANT_ID, part.REVIEW_ROLE_NAME, cate.PARTICIPANT_CATEGORY, cate.IS_CURRENT_FLAG, part.IS_DRAFT_REP_RECIPIENT, part.IS_FINAL_RECIPIENT,part.IS_REVIEW_PARTICIPANT FROM PMACCR.CCR_REVIEW_PARTICIPANTS part, PMACCR.CCR_REVIEW_PARTI_CATEGORY cate WHERE part.PARTICIPANT_CATEGORY_ID = cate.PARTICIPANT_CATEGORY_ID AND part.REVIEW_ID = :reviewId

Oracle Community | 2985623 | 7 months ago
  1. 0

    Query works in SQL*Plus but in adf it gives JBO-27122 error

    Oracle Community | 7 months ago | 2985623
    javax.faces.el.EvaluationException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT part.PARTICIPANT_CATEGORY_ID, part.PARTICIPANT_EMAIL, part.PARTICIPANT_NAME, part.REVIEW_ID, part.REVIEW_PARTICIPANT_ID, part.REVIEW_ROLE_NAME, cate.PARTICIPANT_CATEGORY, cate.IS_CURRENT_FLAG, part.IS_DRAFT_REP_RECIPIENT, part.IS_FINAL_RECIPIENT,part.IS_REVIEW_PARTICIPANT FROM PMACCR.CCR_REVIEW_PARTICIPANTS part, PMACCR.CCR_REVIEW_PARTI_CATEGORY cate WHERE part.PARTICIPANT_CATEGORY_ID = cate.PARTICIPANT_CATEGORY_ID AND part.REVIEW_ID = :reviewId
  2. 0

    JBO-27122: SQL error during statement preparation in OAS 10.1.3.4

    Oracle Community | 6 years ago | 788094
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select user_id user_id from apps.fnd_user where user_name =:SSOUse rName
  3. 0

    oracle.jbo.SQLStmtException: JBO-27122:  On  ViewLink traversal

    Oracle Community | 1 decade ago | 336358
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PerEo.PERIDN, PerEo.NATOFPER, PerEo.PERSTAT, PerEo.PERSTATCHGD FROM PER PerEo WHERE (AliasEo.PERIDN = ?)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    SQL View Objects - setWhereClause()

    Oracle Community | 1 decade ago | 405015
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select distinct dept from dept where dept!='*****' and inst=:1 and guide_yr=:2
  6. 0

    socket error/ where-clause

    Oracle Community | 1 decade ago | 100443
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT AdrInhaber.OID, AdrInhaber.TYP, AdrInhaber.SYN FROM jy.PEAD_ADRESS_INHABER AdrInhaber WHERE AdrInhaber.TYP='FA'

    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.jbo.SQLStmtException

      JBO-27122: SQL error during statement preparation. Statement: SELECT part.PARTICIPANT_CATEGORY_ID, part.PARTICIPANT_EMAIL, part.PARTICIPANT_NAME, part.REVIEW_ID, part.REVIEW_PARTICIPANT_ID, part.REVIEW_ROLE_NAME, cate.PARTICIPANT_CATEGORY, cate.IS_CURRENT_FLAG, part.IS_DRAFT_REP_RECIPIENT, part.IS_FINAL_RECIPIENT,part.IS_REVIEW_PARTICIPANT FROM PMACCR.CCR_REVIEW_PARTICIPANTS part, PMACCR.CCR_REVIEW_PARTI_CATEGORY cate WHERE part.PARTICIPANT_CATEGORY_ID = cate.PARTICIPANT_CATEGORY_ID AND part.REVIEW_ID = :reviewId

      at oracle.jbo.server.BaseSQLBuilderImpl.processException()
    2. oracle.jbo.server
      ViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3735)
      2. oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4725)
      3. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1491)
      4. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:1005)
      5. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7515)
      5 frames
    3. com.oracle.ptsdemo
      EmailDraftVOImpl.executeQueryForCollection
      1. com.oracle.ptsdemo.uiaccelerator.RSWPuview.EmailDraftVOImpl.executeQueryForCollection(EmailDraftVOImpl.java:27)
      1 frame
    4. oracle.jbo.server
      ViewObjectImpl.executeQuery
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1260)
      2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1458)
      3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1364)
      4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1349)
      5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:7410)
      5 frames
    5. oal.oracle.apps
      PublicationFeedbackSetupBean.populatePublicationSetup
      1. oal.oracle.apps.RSWPbean.PublicationFeedbackSetupBean.populatePublicationSetup(PublicationFeedbackSetupBean.java:69)
      1 frame
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    7. EL
      AstValue.invoke
      1. com.sun.el.parser.AstValue.invoke(Unknown Source)
      1 frame