My Oracle Support Banner

RetroPay Status Page Is Allowing Duplicate Lines For Terminated or Ex-Employees. (Doc ID 2976921.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP14 and later
Information in this document applies to any platform.


Allowing to create duplicate lines for ex-employees in Retro pay status page. This works fine in active employee.
It should not allow to enter duplicate rows or entries in Retro pay status page. It should behave as like active employees.

1. Login with HRMS Manager Responsibility
2. Navigate: View > Retropay Status
3. Enter or create Retro Lines for the ex-employee for the past date

Employee has been terminated on 07-JUL-2023
Payroll has been run for JUL2023, as the employee has retropay payment, business user backdated to 07-JUL-2023 and tried to search for the record.
As they didn't see the retro-payment, user is manually added the line and submitted the retro program,

4. As page is allowed duplicate lines, the retro pay process failed with error saying that "Error ORA-01422: exact fetch returns more than requested number of rows"


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.