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 JULY 04, 2016

Applies to:

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

Symptoms

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

ORA-01422: exact fetch returns more than requested number of rows in Package hr_person_absence_swi Procedure create_person_absence.



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

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