My Oracle Support Banner

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

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