463 total views
In this article we will look into the HDL Error Report which is widely used to diagnose any errors that come across during HDL data load.
This is not a replacement for the seeded “HCM Data Loader Error Analysis Report” diagnostic test. However it might not be possible every time to run the diagnostic test and the diagnostics will not provide data in a user friendly format. This report is a custom report and can be modified to fit in as per the client’s requirement.
This custom HDL Error report is initially shared by the Oracle CoE team on Oracle Blog. However the posted version doesn’t work for the protected datasets like Element Entries and needs to be tweaked from 20C patch.
Similar question was posted in our Telegram Group and one of the Member by name Rahul Singu was kind enough to share the updated version of the Data Model which works for Element Entries as well post 20C.
I took the data model provided by Rahul and made some tweaks to have the Content ID as LOV and made couple of changes and tagged it to the report templates and here is how the latest Error Report looks like:
HDL Load Summary Tab:
Error Count Tab:
Error Details Tab:
Note: This HDL Error report works for 20C version and might not work in future versions if Oracle changes the backend tables which stores the data.
HDL Error Report Catalog File: Download Link
Feel free to modify it as per your requirement.
Latest posts by Sricharan Monigari (see all)
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh - November 16, 2020