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
The customer is trying to do timecard submission for a group of employees in Timekeeper and that fails with following errors:
### Error Message ###
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
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