In this article we will look into the new subject area “HCM Integrations Real Time” introduced from 20D release which lists the HCM Data Loader import details and HCM Extract design and execution details.
We did not have any seeded report to fetch these details and Oracle providing this subject area is a welcome move in the right direction. I could not find any privilege/role which provides access to this subject area, however, as this is related to integrations the seeded “Human Capital Management Integration Specialist” should have the privilege required to access this subject area.
Table of Contents
HDL Import Summary Analytics
With this analytic, we can find out all the HDL imports and their corresponding status and the number of rows processed and failed.
Here are the attribute and Facts details from HCM Data Loader folder:

Here is the output from a POD which is updated to 20D.


HCM Extract Run Details Analytics
With this analytic, we can find out all the HCM Extract run details and their corresponding status.


Payroll Process Configuration Group Analytics
We can also extract all payroll process configuration groups with their parameter values using this subject area.


Download Catalog Files:
HCM Extract Run Details Report – Download Link
HCM Data Loader Import Summary Report – Download Link
Process Configuration Groups Report – Download Link
Feel free to use them and modify it as per your requirement.
If you have any feedback leave them in comments section.