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 | 10 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

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

    Oracle Community | 10 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

    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