ORA-20001:The Effective Dates On This New Element Entry Are Invalid.

(Doc ID 1969464.1)

Last updated on APRIL 24, 2015

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Manage Compensation

Error when running posting compensation data to HR.

-20001:ORA-20001: The effective dates on this new element entry are invalid. This entry causes an overlap with an existing entry for the same element. Details: Multiple entries are not allowed for this element. You cannot have two simultaneous entries for it, where the effective dates overlap, and the two entries would coexist on the same payroll relationship, employment terms, or assignment. You can update the existing entry with new effective dates or select different effective dates for the new record.

The issue can be reproduced at will with the following steps:
1. Login to Fusion Application.
2. Error when running posting compensation data to HR.


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