My Oracle Support Banner

Retropay (Enhanced) Errors with Error SQL-02112: SELECT..INTO returns too many rows (Doc ID 1678482.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


When attempting to run Retropay (Enhanced), the following error occurs.

Error SQL-02112: SELECT..INTO returns too many rows has occurred in table pay_element_links_f at location 4516



Steps to Reproduce:
The issue can be reproduced at will with the following steps.

1. Submit Retropay (Enhanced) process



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!


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