Error : JBO-27122 When Attempting to View Appraisee Questionnaire Details in an Appraisal by Main Appraiser

(Doc ID 2002096.1)

Last updated on MARCH 06, 2017

Applies to:

Oracle Performance Management - Version 12.2.4 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Problem Statement:
When attempting to view appraisee questionnaire details in an appraisal by main appraiser, the following error occurs.

Error:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM
(SELECT QuestAnswerValueEO.QUEST_ANSWER_VAL_ID,
     QuestAnswerValueEO.QUESTIONNAIRE_ANSWER_ID,
     QuestAnswerValueEO.FIELD_ID,
     QuestAnswerValueEO.OBJECT_VERSION_NUMBER,
     QuestAnswerValueEO.VALUE,        
     QuestFieldEO.FIELD_ID AS QUEST_FIELD_ID,
     QuestFieldEO.NAME,
     QuestFieldEO.TYPE,
     QuestFieldEO.HTML_TEXT,
     rank() over (partition by QuestFieldEO.NAME order by
QuestFieldEO.FIELD_ID) AS RANK,
     QuestAnswerValueEO.QUESTIONNAIRE_ANSWER_ID AS QUESTIONNAIRE_ANSWER_ID1,
     decode (QuestFieldEO.validation_type
             ,'LOOKUP'
             ,
              (
              SELECT  hl.meaning
              FROM    hr_lookups hl
              WHERE   hl.lookup_code = QuestAnswerValueEO.value
              AND     hl.lookup_type = QuestFieldEO.validation_detail
              AND     hl.enabled_flag = 'Y'
              )
             ,'RATINGSCALE'
             ,
              (
              SELECT  (prat.step_value
                      || ' - '
                      || prat.name)
              FROM    per_rating_levels_vl prat
              WHERE   to_char (prat.rating_level_id) = QuestAnswerValueEO.value
              AND     to_char (prat.rating_scale_id) = QuestFieldEO.validation_detail
              )
             ,QuestAnswerValueEO.value) ANS
     FROM HR_QUEST_ANSWER_VALUES QuestAnswerValueEO, HR_QUEST_FIELDS QuestFieldEO
     WHERE QuestFieldEO.QUESTIONNAIRE_TEMPLATE_ID(+) = :1
           and QuestAnswerValueEO.QUESTIONNAIRE_ANSWER_ID(+) = :2
           AND QuestFieldEO.FIELD_ID = QuestAnswerValueEO.FIELD_ID (+)) QRSLT
 ORDER BY QUEST_FIELD_ID
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)
      ...
      ...
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1899)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3764)
...

 
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1.   Create an publish a Performance Management Plan (PMP) without Objective Setting.
2.   Login as an appraisee.
3.   Go into Employee Self-Service > Performance Management.
4.   Next page is 'Performance Management Task List'.
      Here clicked on 'Go to Task' for 'Appraisal' Task.
5.   Update the appraisal and enter the Questionnaire section.
6.   Share the appraisal with the main appraiser.
7.   Click on 'Details' icon to open the appraisal.
8.   Navigate to the region 'Questionnaire: Appraisee'.
9.   Click on 'Show Questionnaire' to see the Questionnaire entered earlier before sharing the appraisal.
10. Then the application throws the OA exception as shown above.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms