Entering a Salary for a Future Dated new Hire,, Error's: ORA_20001 Database constraint violated. The database check or unique constraint BEN_PTNL_LER_FOR_PER_DT2 has been violated.

(Doc ID 1210374.1)

Last updated on JUNE 13, 2018

Applies to:

Oracle Advanced Benefits - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When entering a salary for a future dated new hire, the following error message is received:

ORA_20001 Database constraint violated. The database check or unique constraint BEN_PTNL_LER_FOR_PER_DT2 has been violated.
Please contact your system administrator quoting the package procedure ben_ppl_shd.constraint_error and constraint BEN_PTNL_LER_FOR_PER_DT2

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