Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to Remove Duplicate data from pay_payroll_assignments (Payroll Relationships)
Summary:
How to Remove Duplicate data from pay_payroll_assignments (Payroll Relationships)
Content (please ensure you mask any confidential information):
Hi Team,
Greetings!
We have run into a situation - for the given employee - there are duplicate records showing up for payroll relationships in the application i.e.
the employee has 2 rows for the same weekly payroll with the same start date.
When we check for the employee details in pay_payroll_assignments table, that has got exactly 2 records with the same value for all the columns ( This is strange as the unique identifier constraint has got violated here).
Tagged:
0