Mass Appraisal Creation ends in warning with ORA-20001: BEN_92460_ASS_SET_FORMULA
(Doc ID 2489286.1)
Last updated on SEPTEMBER 09, 2024
Applies to:
Oracle Performance Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run Mass Appraisal Creation
the following error occurs.
ERROR
-----------------------
ORA-20001: Main appraiser does not exist as of effective date. -> for 12 employees
ORA-20001: BEN_92460_ASS_SET_FORMULA: N, PROC, ben_evaluate_elig_profiles.check_asnt_set, N, ELIGY_PRFL_ID, 2001 -> for 3678 employees
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Plan - Performance Dialogue 2018 is created and published -> HIERARCHY_TYPE_CODE : ORG / TOP_ORGANIZATION_ID : 123 / ORGANIZATION_STRUCTURE_ID : 456
2. Assignment Set is used in the Eligibility Profile and used the eligibility profile in the Performance Management Plan appraisals
3. Run Mass Appraisal Creation -> ends in warning
ORA-20001: Main appraiser does not exist as of effective date. -> for 12 employees
ORA-20001: BEN_92460_ASS_SET_FORMULA: N, PROC, ben_evaluate_elig_profiles.check_asnt_set, N, ELIGY_PRFL_ID, 2001 -> for 3678 employees
4. Workers by Process Status:
Successful -> 76
Warning -> 0
Error -> 3690
Workers by Eligibility:
Eligible -> 88
In Eligible -> 3678
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 |