You are currently viewing HCM Extracts Design and Run Time Diagnostics Reports
HCM Extracts Design and Run Time Diagnostics Reports

In this article we will look into the Design Time Diagnostics Report for HCM Extracts which is available from 20C release. This is part of the Extract Process Diagnostics Report which is already present since long as Run Time Diagnostics Report.

These reports are used to diagnose the extract design issues and run time performance issues.

Let’s look into more details now.

Navigate to Tools > Scheduled Processes
Search for “Extracts Process Diagnostics Report” and submit

image 6 - HCM Extracts Design and Run Time Diagnostics Reports
Extract Process Diagnostics Report

Click OK.

image 7 - HCM Extracts Design and Run Time Diagnostics Reports
Select the Scope

Scope has two values now:
Design Time Diagnostics – This is new from 20C.
Runtime Diagnostics – This is already existing from old releases.

Table of Contents

Design Time Diagnostics Report

The process will analyze the current extract, data groups used, threading dbi, joins between data groups, etc. and will present a readable output

  • Usage of RESET UEs in the extracts definition
  • Threading DBI usage for incremental and changes-only extracts
  • Usage of historic UEs in threading data groups
  • Delivery options and the associated BIP reports, if any
  • Design practices that are commonly seen to impact extracts performance including usage of advanced conditions, override conditions, and record the sort order

Let’s run the Design Time Diagnostics Report for a sample extract and look at the output:

image 8 - HCM Extracts Design and Run Time Diagnostics Reports
Design Time Diagnostics Report

After the Scope is selected, we need to select the Scope Value as HCM Extract Name and then click Submit.

image 10 - HCM Extracts Design and Run Time Diagnostics Reports
Download the log file

Once the process is complete, download the log file to check the design recommendations set by Oracle.

Here is how the sample Design Diagnostics Report would look like:

image 15 - HCM Extracts Design and Run Time Diagnostics Reports
Design Diagnostics Report – Part 1

This provides an overview of the totals of attributes, report categories, records, etc.

image 11 - HCM Extracts Design and Run Time Diagnostics Reports
Diagnostics Report – Part 2

Here is the list of possible solutions for the issues in the extract. It also lists the User Entities last updated date which gives us an option to check if the UEs have changed recently.

image 13 - HCM Extracts Design and Run Time Diagnostics Reports
Design Diagnostics Report – Part 4

It also lists the Data Groups, Parameters, Data Groups which have been modified in the last 15 days. If someone has modified them inadvertently then you can take some action based on this report.

image 14 - HCM Extracts Design and Run Time Diagnostics Reports
Design Diagnostics Report – Part 5

In the extract there was an XML delivery option, so the report suggested to remove the ‘XML’ delivery option in production. It also mentions the usage of Predictive DBIs. not sure what predictive dbi means.

Hope it makes sense to run the Design Time Diagnostics Report after the Extract is developed and implement the possible solutions for the issues.

Runtime Diagnostics Report:

This report will present the stats for the extract run and compares timings with the previous runs.

For this Scope, we need to select the Scope Value as the Flow Instance Name of the Extract. Here is what the sample output will look like:

image 16 - HCM Extracts Design and Run Time Diagnostics Reports
Runtime Diagnostics Report – Part 1

It will list the parameters that were used to run the extract. Including the number of threads if multi-threading has been used. It will also break the total extract run time into phase wise timings.

Overall Timing Summary Explained

Preprocessing : Processes the objects for the data group with threading DBI and for the data groups below in the extracts data hierarchy. Use threading database item, review the Fast Formula or array DBI or optimize filter criteria to improve throughput.

Archive processes : Number of process threads, volume of data processed, usage of array DBI and functions in rule formula may impact the run time for this phase. Review user entities you use in your extract definition.

Root data group extract : Processes the data for the data groups above the data group with the threading DBI in the extracts data hierarchy. Improve the throughput by reviewing the filter criteria or criteria formula.

XML Generation : Generates the XML file for the extracted data. Improve throughput by running extracts in incremental or changes only mode and by using XML multi-threading, without summary or grouping functions.

XML Delivery : XML with None Delivery is targeted in this phase. Customer should not use None+XML in production.

Formatting in BIP : Formats the generated XML file using the report templates in the extract definition. The volume of data being formatted, template design, and grouping and sorting functions in the reports template impacts the throughput.

Report delivery : Delivers the formatted extract output files to the content server.

XML Delivery to UCM :Delivers the generated XML to the content server. Use compress option to improve the throughput.

image 17 1024x472 - HCM Extracts Design and Run Time Diagnostics Reports
Runtime Diagnostics Report – Part 2

This also compares the last 5 runs timings and counts which gives us a fair idea on if something has changed in the last 5 runs to figure out any issues.

image 18 - HCM Extracts Design and Run Time Diagnostics Reports
Runtime Diagnostics Report – Part 3

It also lists the output XML size and the content ID from UCM.

Attachments:
Design Time Diagnostics ReportClick Here
Run Time Diagnostics ReportClick Here

Hope this article gives you a fair understanding and the benefits of using the Design Time and Runtime Diagnostics Options for HCM Extracts.