My Oracle Support Banner

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:
Exception Details
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT


## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer.processError(

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

A. Prequisite:

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
10.Manager Self-Service
11.Appraisal in Progress.
    See the Ongoing with Main Appraiser appraisal of your worker.
12.Click Appraise
13. Update Appraisal button
14. Click update details for the competence set with multiple grades at competence requirements level
15. The error is coming

Patch 20390905:R12.PER.B.




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.