My Oracle Support Banner

Timekeeper submission Errors With Fdpstp Failed Due To ORA-01422: Exact Fetch Returns (Doc ID 367544.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

Oracle Time and Labor - Version 11.5.8 to 12.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Feb-2011***
HXT-F1 patch level and using Timekeeper functionality


Symptoms

The customer is trying to do  timecard submission for a group of employees in Timekeeper and that fails with following errors:

### Error Message ###
**Starts**26-APR-2006 07:43:16
ORACLE error 1422 in FDPSTP

Cause: FDPSTP failed due to ORA-01422: exact fetch returns more than requested
number of rows
ORA-06512: at "APPS.PAY_HXC_DEPOSIT_INTERFACE", line 500
ORA-06512: at "APPS.PAY_HXC_DEPOSIT_INTERFACE", line 986



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

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