Position Update, Erro:r APP-PER-07877 Database constraint violated

(Doc ID 1305916.1)

Last updated on JULY 19, 2016

Applies to:

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

Symptoms

When attempting to update a position definition on a future date the following error occurs.

APP-PER-07877 Database constraint violated
The database check or unique constraint PER_POSITIONS_UK2 has been violated.



Steps to Reproduce:
The issue can be reproduced at will with the following steps:


1. A position has been ended and it's name has been changed on the relevant date to be suffixed with 'old'.
2. From that same date a new position has been created with the original name of the old position.
3. Datetrack back and query the old position
4. Update the position and save

 

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