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.

Summary:

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:

References:

https://docs.oracle.com/en/cloud/paas/integration-cloud/hcm-adapter/subscribe-atom-feeds-scheduled-integration.html

https://www.oicbasics.com/2022/04/subscribe-to-hcm-cloud-atom-feeds.html?m=1