Updating Appraisals Using Hr_appraisals_api, Getting Error - Main Appraiser Does Not Exist
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.
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.
'Main appraiser does not exist as of effective date'
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.
WHERE appraisal_id = 396803;
(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'
DBMS_OUTPUT.put_line ('Error in Update_Appraisal => ' || SQLERRM);
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