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 FEBRUARY 22, 2023

Applies to:

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

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

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
Symptoms
Cause
Solution
References


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