My Oracle Support Banner

Error Occurs when Entering a LOA for an Employee after Closing & Reopening an Element (Doc ID 555600.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Human Resources - Version 12 and later
Information in this document applies to any platform.
This problem can occur on any platform.


To prevent users from taking a leave of absence in the previous year, the element is closed for entry at the end of the year. Then it is reopened again for data entry at January 1st.

When entering a LOA then, an error occurs:
ORA-01422 exact fetch returns more than the requested number of rows
ORA-06512 at "APPS.HR_PERSON_ABSENCE_API" line 876


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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