Fusion Global Payroll - Unwanted Retroactive Entry Triggered for Old Element Error ORA-20001: The payroll relationship or assignment isn’t eligible for the element (Doc ID 2866201.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Symptoms

On : 11.13.21.10.0 version, Global Payroll

When attempting to run Retro payroll flow (task details: Recalculate Payroll Retroactive Changes)
the following error occurs.

ERROR
-----------------------
Error message:
A system error ORA-20001: The payroll relationship or assignment isn’t eligible for the element XXXX Retroactive on the date 2022-04-01. Details: Check if the employment record for the person meets the eligibility criteria defined for the element.
ORA-06512: at “FUSION.PAY_RETRO_PKG” line 2058
ORA-06512: at “FUSION.PAY_ELEMENT_ENTRY_API” line 468
ORA-06512: at “FUSION.PAY_PROC_LOGGING” line 607
ORA-06512: at “FUSION.PAY_ENTRY_PKG” line 5350
ORA-06512: at “FUSION.PAY_ELEMENT_ENTRY_API” line 265
ORA-06512: at occurred in table pay_retro_pkg.create_retro_entry at location 3065.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Recalculate Payroll Retroactive Changes
2. Process errors for one employee

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.