Delete Future Date Absence using HDL
Hi Oracle,
We want to delete future dated absence record for employees using HDL but we are getting the below error.
HDL File:
METADATA|PersonAbsenceEntry|PersonNumber|AbsenceType|AbsenceReason|AbsenceStatus|ApprovalStatus|SubmittedDate|NotificationDate|StartDate|StartTime|EndDate|EndTime|Employer
DELETE|PersonAbsenceEntry|142422|Diversity Days||SUBMITTED|AWAITING|2020/01/13||2020/07/27|00:00:00|2020/07/30|23:59:00|Dresser-Rand Canada ULC
Error:
You can't delete this row because either the values are invalid or missing
Thanks,
Shivam