Updating Appraisals Using Hr_appraisals_api, Getting Error - Main Appraiser Does Not Exist (Doc ID 2270209.1)

Last updated on MAY 25, 2017

Applies to:

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

Symptoms

On 12.1 HRMS RUP 7 version of Production Instance, In the Appraisal Page.

When attempting to Execute the API "HR_APPRAISALS_API", to Update an Completed Appraisal, got the following error occurs.

ERROR
-----------------------

'Main appraiser does not exist as of effective date'

STEPS
-----------------------

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

1. Executing the API "HR_APPRAISALS_API" to update an completed Appraisal, using the below wrapper code.

2. When updating using System Date, when the Main Appraiser is an Ex - Employee, got the above error message.

3. Same error message pops up when we pass other date during which the Main Appraiser is an Active Employee as well.

Wrapper Code:
-----------------------

DECLARE
ln_object_version_number NUMBER;
BEGIN
SELECT object_version_number
INTO ln_object_version_number
FROM per_appraisals
WHERE appraisal_id = 396803;

hr_appraisals_api.update_appraisal
(p_effective_date => TRUNC(SYSDATE) --TO_DATE ('27-Feb-2017'),
p_appraisal_id => 396803,
p_object_version_number => ln_object_version_number,
p_appraiser_person_id => 894,
p_attribute10 => 'Changed by SYSDAMIN'

);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.put_line ('Error in Update_Appraisal => ' || SQLERRM);
END;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms