Oracle HCM Cloud: Mass Load Global Temporary Assignment Transactions with the Oracle Integration Cloud Service (OIC)

Hi, community,

I have been noticing an increasing demand for the Oracle Integration Cloud Service (OIC) for the last couple of years. It is getting extremely strong and keep expanding on new markets. OIC provides a zero-coding (I would say low code) approach for building, deploying, and managing enterprise integration services.
I decided to expand my integration knowledge with this service (inspired by Alex MacDonald GitHub) and build some useful scenarios.
In this blog, I would like to share my experience working with OIC.
You might have read my article – Oracle HCM Cloud: Mass Load Internal Mobility Employee Transactions with a Worker REST API.
It shows how to load internal mobility transactions with a Python code.
I decided to replicate the same process with the OIC service.
OIC is supplied with a large set of predefined adapters. So I used the Oracle HCM Cloud adapter to invoke HCM rest APIs.
It took me two days to build up a simple integration process. It is just for demonstration purposes and, of course, it should be expanded with error/file handlings, etc.

This is the integration orchestration flow:

Below are the orchestrion flow steps:

  • Read file from SFTP
  • For each person number in the input file
  • Get an employee self link
  • Get work relationships by provided link
  • Pass a WR link to the changeLegalEmployer operation

Concludes the post a brief video that demonstrates the described integration scenario in action:

I hope you find this useful.


Building Oracle HCM Cloud outbound integration scenarios based on OCI resources

In the last couple of years, we have seen Oracle Cloud Infrastructure is getting a reputation for reliability and becoming a key player in the cloud market.
A few months ago I also cleared Oracle Cloud Infrastructure 2019 Certified Architect Professional and Oracle Cloud Infrastructure 2019 Certified Architect Associate certifications.

It’s now time to get hands dirty with OCI services. I have my personal free OCI account and the idea was to use only free resources to try to build a practical solution.

Well, recently I have been asked for the possible ways how to synchronize downstream or co-existent applications with the HR data that are maintained in the Oracle HCM Cloud system in real time. It depends on detailed requirements but in general, there is a solution that allows polling HR events (referential data updates as well as employment transactions). I am talking about the Atom feeds feature. You can review my blog where I have explained the Atom feeds feature in details.

Continue reading