My Oracle Support Banner

UK: Full Payments Submission (FPS) Error - ORA-01422: Exact Fetch Returns More Than Requested Number of Rows (Doc ID 2704752.1)

Last updated on AUGUST 26, 2020

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:
When attempting to run FPS program, the following error occurs for one employee:

 

ORA-20001: An error encountered was - ORA-01422: exact fetch returns more than requested number of rows


Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Run RTI - Full Payment Submission (FPS)
2. Check in assignment process results or process output


Changes

 

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
Changes
Cause
Solution


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