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.

Symptoms

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

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