My Oracle Support Banner

Error in ben_eligy_crit_values_fk1 when Attaching an ELPRO to a Grade Ladder (Doc ID 2093454.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Orgs,Jobs,Locs,Positions etc

Customer created a user defined eligibility profile.
When attaching this profile to grade ladder via grade/step progression page under total compensation, the following error occurs:

Process failed to copy - COP_XXXXXX_RULE. The error encountered is: Database constraint violated. The database check or unique constraint BEN_ELIGY_CRIT_VALUES_FK1 has been violated. Please contact your system administrator quoting the package procedure ben_ecv_shd.constraint_error and constraint BEN_ELIGY_CRIT_VALUES_FK1.


The issue can be reproduced at will with the following steps:
1. Create a user defined eligibility profile
2. Attach the profile to grade ladder


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.