23259092:Error With Batch Loader - ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2162998.1)

Last updated on JULY 29, 2016

Applies to:

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

Symptoms

When attempting to create element entry for Deferred Cash element 2017,
the following error occurs.

ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FUSION.PAY_BATCH_LDR_PKG", line 1846
ORA-06512: at line 1


The issue can be reproduced at will with the following steps:
1. Login to application and navigator > My Workforce > Person Management
Search Employee 000196 as of effective date 3/15/17
2. Go to element entry page
3. Click on Deferred Cash 2017 element entry and in correction mode change the input values and Save it.

Following error message in appear:

The message is ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "FUSION.PAY_ELEMENT_ENTRY_API", line 1153 ORA-06512: at line 32


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