My Oracle Support Banner

Position Update, Erro:r APP-PER-07877 Database constraint violated (Doc ID 1305916.1)

Last updated on MARCH 09, 2022

Applies to:

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


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



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.