My Oracle Support Banner

Fusion Global Payroll - Element Entries Issue: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2918963.1)

Last updated on JULY 05, 2023

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Global Payroll

When attempting to create an element entry for an employee, the following error occurs.

The message is ORA-01422: exact fetch returns more than requested number of rows
line 468 ORA-06512: at "FUSION.PAY_ENTRY_PKG",
line 4964 ORA-06512: at "FUSION.PAY_ENTRY_PKG",
line 5012 ORA-06512 at "FUSION.PAY_ENTRY_PKG",
line 5100 ORA-06512 at "FUSION.PAY_ELEMENT_ENTRY_API",
line 326 ORA-06512: at line 53.

The issue can be reproduced at will with the following steps:
1. Person Management - Search for Employee
2. Access Employment data
3. Click on Element Entries
4. Create Element Entry
5. Add Amount in the Entry Values
6. Click Submit
7. Encounter error message.


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.