My Oracle Support Banner

Hr_assignment_api.update_emp_asg_criteria Fails With Single Incumbent Position (Doc ID 2234307.1)

Last updated on OCTOBER 16, 2023

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.




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.