HDL Error Report (BI Publisher)
AUGUST 2016
SUNIL KASHYAP,STEPHANE COTE AND PRASANNA BORSE
Oracle Fusion HCM Center of Excellence (CoE)
Table of Contents
Introduction 2
Pre-requisites 2
Report Layout 3
Sample Reports 5
Appendix 6
Troubleshoot 8
.
Introduction
This document outlines the usage of HDL error report based on BIP. This report is not a replacement for the out of
the box functionality , instead it’s a custom report which can be modified to fit your needs.
The report provides summary, error count and error details of a specific HDL batch. The report takes Content ID as
the main input and error string as the alternate key (only applicable when searching for error count and details) to
search a part or the complete error message.
The report adds value by grouping the errors along with the error counts and provides the location of the error
which is not provided on the UI. The report enables the users to download the report in multiple formats like
HTML, PDF, RTF, Excel and PowerPoint. It is assumed that the reader of this document is well aware of Oracle
Fusion HCM Data Loader (HDL) and BI Publisher (BIP) tools.
Pre-requisites
The Fusion environment must be version 10 or greater
Access to BI Publisher
HDL ERROR BIP REPORT
Report Layout
The report has three sections-
1- Summary:
This section provides an overall summary for a specific HDL batch. The report includes both Import and Load error
counts along with the object level summary which includes the individual file level details.
2- Error Count:
The tab is an extension of summary and serves the purpose of providing details on what went into error. It includes
the error count grouped across the business object and error message. There is an option to perform a lookup on
error string on this section. Note that the search field “ErrorString” expects the ‘%’ before and at the end of the
string.
HDL ERROR BIP REPORT
3- Error Detail:
This tab provides more detailed information about the error(s). The output includes file line, error location and the
stack trace which might be very helpful in diagnosing a specific error signature. Just like error count tab, the report
can take error string as an input and perform search.
HDL ERROR BIP REPORT
Sample Reports
Error details with import errors:
Error string search on Error Count tab-
Error string search on Error Details tab-
HDL ERROR BIP REPORT
Appendix
How to deploy HDL Error Report in BI Analytics and run the report.
This section provides the steps to deploy HDL Error Diagnostic BI reports into POD. Below file should accompany
this document:
o HDLErrorReport.catalog (Download the zip file attached below)
HDLErrorReport.zip
Please follow the below steps to install the report for HDL Error Diagnostic Report:
1. Login to Bi using direct URL such as:
https://bi-aufsn4x0POD.oracleoutsourcing.com/analytics/
Or
https://POD-test.bi.us2.oraclecloud.com/analytics/
Where POD is the pod name using HCM_ADMIN / PASSWORD
2. Click on “Catalog”
HDL ERROR BIP REPORT
3. Highlight “My Folders” and Click on “unarchive” at the bottom under Tasks
4. Click the browse button to select the .catalog from the folder where it is stored. “HDLErrorReport.catalog”
will default as the Archive file name. Select Replace=All and hit “OK” button
5. Once uploaded, open HDLErrorReport folder and run the reports
HDL ERROR BIP REPORT
Troubleshoot
Depending how the report is deployed into your POD and to which folder it is mapped, there is a possibility you will
encounter the below error when you run the report the first time-
Solution: This error occurs when the data model is not correctly referenced to the data model object on the report.
Steps to fix-
Click “Edit” on HDLErrorReport definition-
HDL ERROR BIP REPORT
Click on the look up (magnifying glass symbol) button
On the selection window, navigate to the folder where the HDL Error BIP report was deployed. Select the data
model that’s on the HDLErrorReport. Hit OK. Re run the report and it should not throw the error anymore.
HDL ERROR BIP REPORT
