Exception Error Raised In HR Professional V4.0 Responsibility JBO-27122 and Missing IN or OUT parameter at index:: 2 (Doc ID 2606252.1)

Last updated on JUNE 05, 2021

Applies to:

Symptoms

When attempting to click on Action for any employee in order to find appraisals using Appraisal function from HR Professional V4.0 responsibility, the following error occurs.

ERROR
-----------------------
You have encountered an unexpected error

Exception details as below

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pa.APPRAISAL_ID,
decode (nvl (pa.appraisal_system_status
,'OLDAPPR')
......................

## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 2
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. (N) HR Professional V4.0 responsibility -> Appraisal function
2. Search by Job and Assignment Category -> employee list is populated
3. Select one employee and click on Action -> error is raised

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Appraisal function from HR Professional V4.0 responsibility

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.