The road to real time Integration with HCM Atom Feeds

The HCM Atom Feeds offer a real time mechanism to subscribe to changes in the application.

The Oracle Integration Cloud HCM Adapter has this capability exposed, but only as a Scheduled Integration (Invoke), since it is not possible to create an AppDriven Integration (Trigger) for the atom feed.

The Atom Feeds appears int the Actions screen of the HCM Adapter.

The next screen shows the available Operations. For this use case, I ll pick the Employee Update, with a maximum of 10 entries.

Some of the changes in HCM are marked as future dated – meaning that they have a specific date when they do become effective. You can choose to fetch those entries (example, provisioning a future new hire)

Looking into the ATOM Feed response we can see 2 repeating elements.

EmployeeUpdateFeed_Update – that contains general employee information.

ChangedAttributes – this contains all the changed attributes with old and new value

The above data structure indicates that we need 2 for-each loops in order to properly process the data.
The first for-each will loop over every Employee.

The second for-each will loop over every changed attribute.

Then we can bring the FTP adapter (the idea is to write a file containing all the employee updates).

Operation: WriteFile

Transfer Mode: Binary

Append: No -> it will create a new file for every Employee

Output: FTP directory

Schema: I provided a basic csv with some sample elements

In the mapping you will have the elements of both for-each.I map the Employee and ChangedAttributes accordingly.

This is how the Integration looks like at the end

Finally we can activate and run the Integration. The monitoring view gives us a visual insight on the number of elements iterated – 9 employees in this case.

And that is exactly the number of created files in the FTP directory. Alternatively, we can choose in the FTP Adapter the option to append , which would write everything into 1 file.