FUSION PAYROLL: How to Resolve ORA-20001: The given link <element name> cannot be deleted as it has entries created for it

(Doc ID 2405351.1)

Last updated on MAY 30, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
----------------------
- When attempting to delete an element's eligibility, the following error message is occurring:

ERROR
------------ ----
- ORA-20001: The given link (Deferred Compensation 401k Roth CPC) cannot be deleted as it has entries created for it
- ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 2062
- ORA-06512: at line 1


EXPECTED BEHAVIOR
--------------------------
- The element needs to be end dated so that it is no longer processed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create PBL worksheet to delete element entries
2. Select appropriate task to end date element entries
3. Delete element entries after desired end date of the element
4. Create PBL worksheet to end date element eligibility.
5. Select appropriate task to end date element eligibility
6. Note error be thrown above.

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