Transfer To GL Report Errors: 'Exact Fetch Returns Multiple Rows'
(Doc ID 2614459.1)
Last updated on DECEMBER 01, 2019
Applies to:Oracle Payroll - Version 12.2.8 and later
Information in this document applies to any platform.
After applying patch 30158543_R12.PAY.C, the Transfer to GL Report errors: "exact fetch returns multiple rows"
The patch allows the report to run successfully, unless it is run for a single employee, in which case it errors with a "exact fetch returns multiple rows" error. Looking at the data returned when run for all employees, it appears the issue is as follows:
There are multiple rows for each element, beyond the 2 that report the debit and credit information. It seems an effective date issue that's causing multiple records to be picked up for each assignment/person/element.
The issue can be reproduced at will with the following steps:
Run Transfer to GL Report for a single employee
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