My Oracle Support Banner

Error When Press Go To Task Manage Appraisal: JBO-27122: SQL Error During Statement Preparation; ORA-01427: Single-Row Subquery Returns More Than One Row (Doc ID 2608384.1)

Last updated on NOVEMBER 12, 2019

Applies to:

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

Symptoms


When a manager clicks on Go To Task in order to put the appraisal rating, the manager gets an error and is unable to carry out the transaction for any employee:

 

ERROR:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf.global_name,ppf.local_name) FULL_NAME,
pa.APPRAISAL_ID,
pa.type,
pa.APPRAISAL_DATE,
pa.appraisal_period_start_date,
pa.appraisal_period_end_date,
nvl(pa.appraisal_system_status, decode(pa.open,'N','COMPLETED','OLDAPPR')) as appraisal_system_status,
'MAINAP' AS Participation_Type,
'DisableUpdate' AS UPD_STATUS,
decode(nvl(pa.appraisal_system_status,decode(pa.open,'N','COMPLETED','OLDAPPR')),'COMPLETED','EnableDelete', 'DisableDelete') AS DEL_STATUS, decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf1.global_name,ppf1.local_name) MAIN_AP_NAME,
HL.meaning AS APPR_STATUS,
'OPEN' AS PARTICIP_STATUS,
decode(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G',ppf2.global_name,ppf2.local_name)APPRAISER_NAME,
'ViewMAAppr' VIEW_ACTION,
'UpdateMAAppr' UPDATE_ACTION,
pa.appraisal_id ACTION_ID,
pa.BUSINESS_GROUP_ID,
pa.APPRAISEE_PERSON_ID,
pa.MAIN_APPRAISER_ID,
HL1.MEANING AS APPR_STATUS_MEANING,
pa.plan_id as PLAN_ID,
decode(nvl(pa.plan_id,-1),-1,'',(Select plan_name from PER_PERF_MGMT_PLANS where plan_id=pa.plan_id )) as PlanName

from
PER_APPRAISALS pa,
PER_ALL_PEOPLE_F ppf,
PER_ALL_PEOPLE_F ppf1,
HR_LOOKUPS HL,
PER_ALL_PEOPLE_F ppf2,
HR_LOOKUPS HL1,
per_appraisal_templates pat
where
(pa.main_appraiser_id = :1 OR (pa.appraiser_person_id = :2 and pa.appraiser_person_id <> pa.appraisee_person_id ))
and pa.appraisee_person_id = ppf.person_id
and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

----------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------


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

 





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

1. Using Manager Self Service responsibility

2. Navigate to Performance Management

3. Click on Go to Task Manage Appraisal > Get error

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