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

HDL for absence entry with same absence name and different status

edited Oct 18, 2023 1:05PM in Human Capital Management 7 comments

Hi Experts,

Greetings of the day!!

We have a requirement to load absences for the same day with different status as shown in the below but we are getting an error (You have supplied a user key or surrogate ID value that's used by an existing record with a different source key.)

METADATA|PersonAbsenceEntry|PersonNumber|PersonId|Employer|EmployerId|AbsenceType|AbsenceReason|StartDate|StartTime|EndDate|EndTime|AbsenceStatus|ApprovalStatus|Comments|AssignmentNumber|SourceSystemId|SourceSystemOwner|StartDateDuration|EndDateDuration|Duration

MERGE|PersonAbsenceEntry|123||Test Legal Employer||Test Leave|Others|19-10-2023|00:00|19-10-2023|23:59|SUBMITTED|APPROVED||E123|ABS_123_1|FUSION|1|1|1

MERGE|PersonAbsenceEntry|123||Test Legal Employer||Test Leave|Others|19-10-2023|00:00|19-10-2023|23:59|ORA_WITHDRAWN|APPROVED||E123|ABS_123_2|FUSION|1|1|1

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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