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

 464 total views

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.

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.

hdl summary report
hdl summary report

HCM Extract Run Details Analytics

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

hcm extract subject area
hcm extract run details summary report

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 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.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

Leave a Reply