What's new in Customer Journeys?

Connect and learn more! ×
How to Remove Duplicate data from pay_payroll_assignments (Payroll Relationships) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Remove Duplicate data from pay_payroll_assignments (Payroll Relationships)

Received Response
15
Views
1
Comments

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).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!