Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

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

edited Apr 10, 2019 2:16AM in Payroll and OTL - EBS (MOSC) 1 commentAnswered

Hi All,

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

Above error is occurring for only few employees.

I read somewhere this is because of "Duplicate Element Links for a Retro element have been created and are NOT mutually exclusive and should have raised error"

But I do not how to find out which element is duplicating.

Can anybody help me on this issue?

Thank you,

~Srinivas Padakanti.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center