Hr_assignment_api.update_emp_asg_criteria Fails With Single Incumbent Position

(Doc ID 2234307.1)

Last updated on JULY 24, 2017

Applies to:

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


Problem Statement:

When attempting to try to update the position of single Incumbent with 'UPDATE_CHANGE_INSERT' of P_DATETRACK_UPDATE_MODE, the following error occurs.

ORA-20001: This Single Incumbent Position has already been assigned as of (11-AUG-14). You must assign a different position to this person to prevent overlap of assignments



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

  1.  Create a position with Single Incumbent Position

  2. Overlap information is set up as below.
    - Overlap Start Date:01-NOV-2016
    - Overlap End Date:30-APR-2017
  3. Assign the position to a person from 01-NOV-2016
  4. Run api to assign it to another person at 01-NOV-2016 or later.(Use hr_assignment_api.update_emp_asg_criteria with 'UPDATE_CHANGE_INSERT')

    P_VALIDATE => l_true
    ,P_EFFECTIVE_DATE => to_date('01-NOV-2016', 'DD-MON-YYYY');
    ,p_position_id => 113472

  5. The Overlap has not been considered, so you can see the error.


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