Employee Absence Synchronization Process (Oracle HCM Cloud Initiated)
The mapping details are shown in the table below:
HCM Extract Absence Bulk File
 
WACS REST Service: W1-Leave (Operation: PUT, URI: /{externalId} )
DVM Mapping
 
Comments
 
Element Name
Parent Element
Type
 
W1UpdLeave
 
Group
 
 
 
input
W1UpdLeave
Group
 
 
 
externalSystem
input
Field
 
Defaulted by Integration. Get value from property name wacs.externalsystem in the ERPWACS_ConfigProps file. This value must exist in WAM.
PERSON_ENTRY_ID
externalId
input
Field
 
This is the ERP's unique system generated Absence ID.
ABSENCE_TYPE
leaveType
input
Field
HCMWACS_AbsenceType
 
TYPE_REASON
description
input
Group
 
Absence Description is optional in WACS. If type reason is populated, use that as the description. If type reason is blank, use comments. If both type reason and comments are blank, no description is passsed.
COMMENTS
description
 
 
 
Absence Description is optional in WACS. If type reason is populated, use that as the description. If type reason is blank, use comments. If both type reason and comments are blank, no description is passsed.
 
applicantId
input
Field
 
WAM Employee ID - Not Mapped
PERSON_ID
applicantExternalId
input
 
 
HCM Employee ID. This external employee ID should exist in WACS.
STATUS_CODE
status
input
Field
HCMWACS_AbsenceStatus
Absence Status. For initial load, HCM send Approved absences only. For incremental load, send Approved and Canceled absences only. Use DVM to translate the ERP status to the equivalent WAM values. *** WAM Statuses: Approved, Inactive and Canceled. ERP Status Code: SUBMITTED and ORA_WITHDRAWN.
START_DATE_TIME
startDateTime
input
Field
 
Map START_DATE_TIME, convert it to xsd format and use the timezone from ABS_START_DATE.
END_DATE_TIME
endDateTime
input
Field
 
Map END_DATE_TIME, convert it to xsd format and use the timezone from ABS_END_DATE.
 
output
W1UpdLeave
Group
 
 
 
leaveId
output
Field