Friday, May 17, 2024

OIC HCM - Subscribe to Atom Feeds in a scheduled integration | Oracle Integration Cloud

Usecase: Here, we will create a Scheduled integration and subscribe HCM Atom Feeds for Employee Update and write them to a FTP directory.


  1. Atom Feeds enable to track changes made to feed enabled resources in Oracle Global Human Resources Cloud and to send them to different downstream applications.
  2. It supports following resources for Atom feeds:
    1. Employee New Hire
    2. Employee Update
    3. Employee Termination
    4. Employee Assignement
    5. Grade
    6. Job
    7. Location
    8. Organization
    9. Position
Logic Implemented steps:
  1. Create a schedule parameter to hold timestamp , which will help to take Atom data after this timestamp. Format: YYYY-MM-DDTHH:MM:SS:sssZ e.g. 2018-06-03T02:34:06.000Z
  2. Configure HCM adapter - subscribe to updates (via Atom Feed) >> select an Atom feed like Employee Update and map the timestamp to updated Min.
  3. Take a for each loop and assign repeating element for employeeupdatefeed_update
  4. Take 2nd inner loop and assign repeating element as changedAtrributes
  5. In the inner loop, configure ftp adapter and write as binary, privide output directory, file name pattern like EmployeeUpdate%SEQ%.csv >> privide sample file where fields are: PersonId,PersonNumber,Attribute,New,Old >> map the required fields.
  6. In the outer loop, update the timestamp using updated_timestamp field of the feed response.

Integration flow:

Detailed screenshots:


No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...