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 JUNE 05, 2021

Applies to:

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

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

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
Symptoms
Changes
Cause
Solution
References


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