Create Absence and get Error: ORA-01422: exact fetch returns more than requested number of rows in Package hr_person_absence_swi Procedure create_person_absence. (Doc ID 2047215.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to create and absence in Employee Self Service get e following error occurs.

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

1. Employee Self Service
2. Click on Function “Absence Management”
3. Click on “Create Absence” to create the absence
4. Enter the details
5. Click on “ Calculate Duration” to calculate the number of days.
6. Click on “Next” on top right corner of the screen.
7. Receive error.

Cause

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