1. Integrating with Oracle HCM Cloud Using an Oracle Integration Accelerator
  2. Oracle HCM-OFS Worker Availability Integration

Oracle HCM-OFS Worker Availability Integration

"Oracle HCM OFS Worker Availability" integration updates the calendar availability of resources from HCM to OFS. The availability of the resource is calculated based on public holidays, resource exceptions in between the assigned work schedules, and absences.

Extract Flow

  • The Oracle HCM OFS Worker Availability invokes the HCM Public Worker API to fetch all the ACTIVE employees in the given business units and given job codes.
  • The Oracle HCM OFS Worker Availability Activity Type, sub integration, checks if the activity type configured in the lookup, Oracle_HCM_OFS_IntegrationVariablesLookup, is already present in OFS. If not present, it will create a new activity type with name and label as configured in the lookup table.
  • The Oracle HCM OFS Worker Availability Helper invokes the API to fetch the partyID for all the eligible employees with valid job codes. If the partyID exist, then this integration will invoke the Worker Availability API to get the resource calendar availability from HCM. If the Worker Availability API returns the schedules, then Oracle HCM OFS Worker Availability Activity Delete and Oracle HCM OFS Worker Availability WS Delete are invoked to clear the activities and schedules in OFS.
  • The Oracle HCM OFS Worker Availability Activity Delete, sub-integration, is invoked to clear all the existing internal activites with apptNumber equal to the Person ID, start date of the activity equal to or greater than the current date and end date of the activity is equal to current date + 'noOfDays' [Intgeration property in Oracle HCM OFS Worker Availability Helper].
  • The Oracle HCM OFS Worker Availability WS Delete sub-integration is invoked to clear all the existing schedules for a resource in OFS for the date range for which the Worker Availability API is invoked.
  • The Oracle HCM OFS Worker Availability Sync Helper iterates and processes each record from the Worker Availability API.
  • The Oracle HCM OFS Worker Availability WS Creator sub-integration is invoked to create custom work schedules in OFS.
  • The Oracle HCM OFS Worker Availability Activity Create sub-integration is invoked to create internal activities in OFS for resource exceptions (breaks in between the work schedules) and half-day leaves from HCM.