Same Competence Requirements with Multiple Grades: Update Details Competency in Appraisals erroring with ORA-01427: single-row subquery returns more than one row
(Doc ID 2028658.1)
Last updated on APRIL 13, 2021
Applies to:Oracle Performance Management - Version 12.1 HRMS RUP7 and later
Information in this document applies to any platform.
On : 12.1.3 version, Appraisals
Employee enters competency ratings in a performance appraisal then shares with Main Appraiser.
When the manager is updating the appraisal, and clicking the Update Details icon available for a competency, the below error occurs.
It's happening only for competencies set with multiple Grades at Competence Requirement level.
The error coming:
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pc.name
## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
The issue can be reproduced at will with the following steps:
1. Create an appraisal template using a competency template with Include Job Competencies checked
2. Set Competence Requirements:
At job level, for one job, add the same competence several times with different Grades (Valid grades may have to be added at job level)
3. Assign a worker to this job and to one grade used at competence requirements level.
4. Create and publish a plan including the worker and with your appraisal template starting by employees.
B. Reproduction of the issue
1. Log in as the employee
2. Employee Self-Service
3. Performance Management
4. See your plan
5. Manage appraisal task > Go to Task
6. See one planned appraisal. Click Update
7. See the competencies automatically created
8. Enter ratings
8. Submit to Main appraiser
9. Log in as the Manager
11.Appraisal in Progress.
See the Ongoing with Main Appraiser appraisal of your worker.
13. Update Appraisal button
14. Click update details for the competence set with multiple grades at competence requirements level
15. The error is coming
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