Navigating to "Manage Time Cards" or "Existing Time Cards" Returns "ORA-01427 single-row subquery returns more than one row" (Doc ID 2742065.1)

Last updated on OCTOBER 19, 2023

Applies to:

Symptoms

After the 20D update, certain users reported an "ORA-01427 single-row subquery returns more than one row" error, when navigating to 'Manage Time Cards' or "Existing Time Cards' to check their submitted time cards.

For example:

1) go to Home/Me/Time and Absences

2) Click on 'Manage Time Cards' or "Existing Time Cards'

3) receive the error: ORA-01427 single-row subquery returns more than one row

Although this is 20D, the Classic UI is still being used.

Changes

Cause

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