You are currently viewing Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D

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:

image 9 1024x477 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D

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

image 13 1024x365 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
image 12 1024x398 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D

HCM Extract Run Details Analytics

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

image 11 1024x388 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
image 10 1024x368 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D

Payroll Process Configuration Group Analytics

We can also extract all payroll process configuration groups with their parameter values using this subject area.

image 14 1024x342 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D
image 15 1024x260 - Now we can extract HDL Import and HCM Extract Run Details in OTBI from 20D

Download Catalog Files:

HCM Extract Run Details ReportDownload 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.