Oracle HCM Cloud: Mass Load Internal Mobility Employee Transactions with a Worker REST API

Many global customers use the internal mobility process. At least 4 of my global customers that have multiple legal entities around the world use this process. What is it? International Mobility, or also known as ‘Global Mobility’, is an HR function that refers to a multinational corporation’s ability to move its people to offices in different countries.
This could be done by initiating a ‘Global Transfer’ or ‘Global Temporary Assignment’ actions in Oracle HCM Cloud.
Normally customers request that GTA transactions will be loaded as part of data migration activities. It’s reasonable if there are hundreds of employees that are involved in the internal mobility process.
The challenge here is that Oracle does not provide HDL templates for these actions at the moment.
You can check the MOS note for details: Is It Possible To Load Global Temporary Assignment With HDL? (Doc ID 2629182.1)
The suggestion is to use REST APIs as Workers REST API supports Global Temporary Assignments.
Well, I decided to come up with a simple Python program to address customer’s requirements to be able to mass load GTAs from an excel spreadsheet using a Worker REST API.
Below is the short video that demonstrates this feature:

Please note that the code provided is only for the demonstration purposes and I have used only mandatory attributes to initiate GTA transaction. Of course, it should be adjusted to fit the real customer requirements.

If you are interested in this feature don’t hesitate to reach out to me.

Kind regards,


Oracle HCM Cloud REST API how-to miniseries I

Hi colleagues,

I would like to start a short series about using REST API in Oracle HCM Cloud. As far as you know, you can use Oracle REST APIs to view and manage data stored in Oracle Applications Cloud and those can be used as a bridge between external applications and Oracle HCM Cloud.
There is a big list of APIs available:

If you are new to REST I would recommend going through my article that describes a concept:

In this post I am going to outline several parameters that may be useful while working with Employees/Assignment REST Endpoints:

  • Limit attributes to be retrieved

To decrease the size of the resulting payload, specify which attributes should be returned by using the fields parameter:
GET hcmRestApi/resources/latest/emps?fields=PersonNumber Continue reading