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 laterInformation 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 |