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 25, 2018
Applies to:Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!