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:

Symptoms

On : 11.13.22.10.0 version, Global Payroll

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

ERROR
-----------------------
The message is ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API",
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.


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

Cause

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