My Oracle Support Banner

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 NOVEMBER 04, 2019

Applies to:

Oracle Performance Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Setup

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.

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

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

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

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




To view full details, sign in with your My Oracle Support account.

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

In this Document

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