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.
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.
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.
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