Supported operations
| DELETE /absences/{id} |
| GET /absences |
| GET /absences/{id} |
| PATCH /absences/{id} |
| POST /absences |
Queryable q fields (79)
Only these fields can appear in a q filter expression on
/absences. Filtering on any other field returns
400 Bad Request.
Example q request
GET /hcmRestApi/resources/11.13.18.05/absences?q=ApprovalDatetime='<value>'&onlyData=true&limit=25
| Field | Type | Operators |
|---|---|---|
| ApprovalDatetime | string | = != |
| ObjectVersionNumber | integer | = != |
| UnpaidBreakDuration | number | = != |
| absenceCaseId | string | = != |
| absenceDispStatus | string | = != |
| absenceEntryBasicFlag | boolean | = != |
| absencePatternCd | string | = != |
| absenceReason | string | = != |
| absenceStatusCd | string | = != |
| absenceType | string | = != |
| absenceTypeId | integer | = != |
| absenceTypeReasonId | integer | = != |
| agreementId | string | = != |
| agreementName | string | = != |
| approvalStatusCd | string | = != |
| assignmentId | integer | = != |
| assignmentName | string | = != |
| assignmentNumber | string | = != |
| authStatusUpdateDate | string | = != |
| bandDtlId | string | = != |
| blockedLeaveCandidate | string | = != |
| certificationAuthFlag | string | = != |
| childEventTypeCd | string | = != |
| comments | string | = != |
| conditionStartDate | string | = != |
| confirmedDate | string | = != |
| consumedByAgreement | string | = != |
| createdBy | string | = != |
| creationDate | string | = != |
| dataSecurityPersonId | integer | = != |
| diseaseCode | string | = != |
| duration | number | = != |
| effectiveEndDate | string | = != |
| effectiveStartDate | string | = != |
| employeeShiftFlag | string | = != |
| employer | string | = != |
| endDate | string | = != |
| endDateDuration | number | = != |
| endDateDurationPreferenceCode | string | = != |
| endDateDurationPreferenceMeaning | string | = != |
| endDateTime | string | = != |
| endTime | string | = != |
| establishmentDate | string | = != |
| frequency | string | = != |
| initialReportById | string | = != |
| initialTimelyNotifyFlag | string | = != |
| lastUpdateDate | string | = != |
| lastUpdateLogin | string | = != |
| lastUpdatedBy | string | = != |
| lateNotifyFlag | boolean | = != |
| legalEntityId | string | = != |
| legislationCode | string | = != |
| legislativeDataGroupId | string | = != |
| notificationDate | string | = != |
| objectVersionNumber | integer | = != |
| openEndedFlag | boolean | = != |
| overridden | string | = != |
| paymentDetail | string | = != |
| periodOfIncapToWorkFlag | string | = != |
| periodOfServiceId | string | = != |
| personAbsenceEntryId | integer | = != |
| personId | integer | = != |
| personNumber | string | = != |
| plannedEndDate | string | = != |
| processingStatus | string | = != |
| projectId | string | = != |
| singleDayFlag | boolean | = != |
| source | string | = != |
| splCondition | string | = != |
| startDate | string | = != |
| startDateDuration | number | = != |
| startDateDurationPreferenceCode | string | = != |
| startDateDurationPreferenceMeaning | string | = != |
| startDateTime | string | = != |
| startTime | string | = != |
| submittedDate | string | = != |
| timelinessOverrideDate | string | = != |
| unitOfMeasure | string | = != |
| userMode | string | = != |
Child resources (9)
Each child is reachable at
/absences/{id}/child/<name>
and most can also be inlined with expand.
absenceAttachmentsabsenceEntitlementUniquePlansabsenceEntitlementsabsenceEntryCertificationsabsenceEntryDetailsabsenceMaternityabsenceRecordingDFFabsenceRecordingsDDFlinkedAbsences Response fields (94)
Top-level attributes returned for each row. Use
fields= to request a subset and shrink the payload.
ApprovalDatetimeObjectVersionNumberUnpaidBreakDurationabsenceAttachmentsabsenceCaseIdabsenceDispStatusabsenceDispStatusMeaningabsenceEntitlementUniquePlansabsenceEntitlementsabsenceEntryBasicFlagabsenceEntryCertificationsabsenceEntryDetailsabsenceMaternityabsencePatternCdabsenceReasonabsenceRecordingDFFabsenceRecordingsDDFabsenceStatusCdabsenceTypeabsenceTypeIdabsenceTypeReasonIdabsenceUpdatableFlagagreementIdagreementNameallowAssignmentSelectionFlagapprovalStatusCdassignmentIdassignmentNameassignmentNumberauthStatusUpdateDatebandDtlIdblockedLeaveCandidatecertificationAuthFlagchildEventTypeCdcommentsconditionStartDateconfirmedDateconsumedByAgreementcreatedBycreationDatedataSecurityPersonIddiseaseCodedurationeffectiveEndDateeffectiveStartDateemployeeShiftFlagemployerendDateendDateDurationendDateDurationPreferenceCodeendDateDurationPreferenceMeaningendDateTimeendTimeestablishmentDateformattedDurationfrequencyignoreWarningFlaginitialReportByIdinitialTimelyNotifyFlaglastUpdateDatelastUpdateLoginlastUpdatedBylateNotifyFlaglegalEntityIdlegislationCodelegislativeDataGroupIdlinkedAbsencesnotificationDateobjectVersionNumberopenEndedFlagoverriddenpaymentDetailperiodOfIncapToWorkFlagperiodOfServiceIdpersonAbsenceEntryIdpersonIdpersonNumberplannedEndDateprocessingStatusprojectIdsingleDayFlagsourcesplConditionstartDatestartDateDurationstartDateDurationPreferenceCodestartDateDurationPreferenceMeaningstartDateTimestartTimesubmittedDatetimelinessOverrideDateunitOfMeasureunitOfMeasureMeaninguserMode Build this query visually in OPAL
OPAL bundles this endpoint — and 59,000+ more — fully searchable offline, with a visual Q Builder and Finder Builder that only offer the fields listed above, so your filter can't 400. Download free · see features.
Related reference & reading
- /learnerLearningRecords Get all assignment records
- /salaries Get all salaries for a worker's assignment
- /positions Get all positions
- /recruitingJobRequisitions Get all recruiting job requisitions
- /personProcessResults Unique identifier for the payroll
- Oracle HCM API guide
- Why the q parameter fails and how to fix it
- Finders: named queries in Oracle Fusion REST APIs
- All endpoint reference pages