Position Update, Erro:r APP-PER-07877 Database constraint violated
Last updated on JULY 19, 2016
Applies to:Oracle Human Resources - Version 18.104.22.168 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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms