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 JULY 18, 2016

Applies to:

Oracle Advanced Benefits - Version 11.5.10.2 and later
Information in this document applies to any platform.
*** Checked for relevance on 19-Mar-2015 ***

Symptoms

On 11.5.10.2 version in Oracle Advanced Benefits,

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