Absence HDL error for PersonAbsenceEntry — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Absence HDL error for PersonAbsenceEntry

edited Jan 23, 2019 11:11AM in Workforce Management 5 comments

Summary

Not to able load absence data - HDL

Content

Hi, While loading absence data , i am getting the below error.Please help on this..

The values 2017-02-14,300000011536310,100000001893845,Test_Vacation are not valid for the attribute AbsenceTypeId.

Here 300000011536310 - Employer Surrogate ID and 100000001893845 - Person Surrogate ID which is present in 'HRC_INTEGRATION_KEY_MAP' table.

The same absence is successfully done through UI  but not through HDL. Any inputs on this

METADATA|PersonAbsenceEntry|SourceSystemOwner|SourceSystemId|PersonNumber|Employer|AbsenceType|AbsenceReason|StartDate|StartTime|StartDateDuration|EndDate|EndTime|EndDateDuration|AbsenceStatus|ApprovalStatus|Duration
MERGE|PersonAbsenceEntry|PSFT|ABEKU01710201703142392|KU0171|GBI|Test_Vacation||2017/02/14|||2017/02/14|||SUBMITTED|APPROVED|8

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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