Search 800 + Posts

Apr 17, 2023

Oracle HCM cloud to OFS Integrations to Integrate Employees/Resources/Users

 In this blog post I will various components of Integration between Oracle HCM and Oracle Field Service Cloud (OFSC). Please note that this is a Shipped by oracle and available as a recipe in OIC, We need to customized this based on Our customer Need. This whole things is organized into 4-5 flows , one each for 

  • New Hire
  • Employee Update 
  • Termination 
  • HCM Extract for 1 time Load
  • HCM Schedule to load Employee Schedule 
  • Event flow that will trigger a new flow to Create /Update data in OFS

Key components of this Integrations are 

  1. Create a Resource in Oracle Field Service When a New Employee is Created in Oracle HCM Cloud
  2. Update Resource Details in Oracle Field Service when Employee Details are Updated in Oracle HCM Cloud.
  3. Suspend a Resource in Oracle Field Service when an Employee is Terminated in Oracle HCM Cloud
there are few other components like 
  • Load all employee ( of type Tech) from HCM to OFS ( Probably one time)
  • Create and Update the Employee Work Schedule Detail


New Hire Flow
At High Level , we just Subscribe to ATOM feed for Operation New Hire and extract the New Employee data







Call  HCM Adapter to get worker Details


Call 2nd Integration to Create Resources and Users in OFS


2nd Integrate Map HCM data with OFS data and create Resources /users


When you create a new employee in Oracle HCM Cloud, a new resource can be created in near-real time in Oracle Field Service. For this, you can use these integrations defined in the Oracle Integration recipe:
  • Oracle HCM OFS New Hire
  • Oracle HCM OFS Event Processor

The Oracle HCM-OFS New Hire integration gets the new employee details from Oracle HCM Cloud in near-real time in a scheduled manner. This integration subscribes to updates through the “Employee New Hire” Atom Feed.  The flow is as follows:

  1. The integration filters the required Employee Assignment according to the Job Code, Business Unit Name, and assignment status "active".
  2. The data (employee Information and the filtered assignment information) is passed on to Oracle HCM OFS Event Processor Integration.
  3. Oracle HCM OFS Event Processor Integration maps the data fetched from Oracle HCM Cloud with Oracle Field Service as defined in the mapping table. Thus, a corresponding Resource and a User is created in Oracle Field Service for the new employee.
  4. The Resource and User are mapped under a bucket (Department from Oracle HCM Cloud) and Organizational Unit (Business Unit from Oracle HCM Cloud). The Resource is also populated with Resource Locations, which correspond to the Employee Home Address and Employee Assignment Location.


Employee Update Flow

You can update the details of an existing resource in Oracle Field Service automatically in near-real time, when an employee details are updated in Oracle HCM Cloud.

This automation is configured using these integrations:
  • Oracle HCM OFS Employee Update

  • Oracle HCM OFS Event Processor

The Oracle HCM OFS Employee Update integration gets the details of employee updates in Oracle HCM Cloud in near-real time in a scheduled manner. This integration subscribes to the Atom Feed “Employee Update”. The flow is as follows:

  1. The integration filters the required Employee Assignment according the Job Code, Business Unit Name, and assignment status "active".
  2. The data (employee Information and the filtered assignment Information) is passed on to Oracle HCM OFS Event Processor Integration.
  3. Oracle HCM OFS Event Processor Integration maps the data received from Oracle HCM Cloud to Oracle Field Service as defined in the mapping table. Thus, the corresponding resource details are updated in Oracle Field Service.

Employee Termination Flow

You can suspend an existing resource in Oracle Field Service automatically in near-real time, when an employee is terminated in Oracle HCM Cloud.

This automation is achieved using two integrations:
  • Oracle HCM OFS Terminate Employee

  • Oracle HCM OFS Event Processor

The Oracle HCM OFS Employee Terminate integration get the details of the terminated employees in Oracle HCM Cloud in near-real time in a scheduled manner. This integration subscribes to the Atom Feed “Employee Terminate”. 

  1. The integration filters the required Employee Assignment according the Job Code, Business Unit Name, and assignment status "active".
  2. The data (employee information) is passed on to Oracle HCM OFS Event Processor Integration.
  3. Oracle HCM OFS Event Processor Integration maps the data received from Oracle HCM Cloud and changes the status of the resource in Oracle Field Service to inactive. It also deletes the corresponding user from Oracle Field Service.



No comments:

Post a Comment