End-dating Position Using HR_POSITION_API.UPDATE_POSITION is Creating More Records. (Doc ID 3036928.1)

Last updated on JULY 24, 2024

Applies to:

Symptoms

PROBLEM STATEMENT

Observed that, Position is not getting end-dated.


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

1. Login to Database.

2. Execute "hr_position_api.update_position" API as below.

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

3. Before executing this script, the position records were like this.

4. After the script was executed, the position records are looking like this.

5. User's expectation is that the Position should get end dated and new record should NOT get created.

Cause

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