My Oracle Support Banner

Duplicate Final Close, Last Standard Processing Date Records / Retropay Error - Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2608161.1)

Last updated on NOVEMBER 11, 2019

Applies to:

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


 When navigating to Manage Payroll Relationships UI for a specific employee, multiple rows of Final Close and Last Standard Processing Date can be seen. 
Because of this, the Recalculate Payroll for Retroactive Changes process fails with the following error:

"A system error ORA-01422: exact fetch returns more than requested number of  rows ORA-06512: at "FUSION.PAY_PAYROLL_RUN". line 2207 ORA-06512 at line 1  occurred in table reset_rel_group_status at location 625"




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

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