In this article we will look into another interesting feature of HCM Extracts which will allow us to read through the HCM Extract in a User Friendly html format.
This tool was created by John Rhodes from Oracle Product Development team and I took his approval before posting this on my website.
John developed an XSL Transformation .xsl file which needs to be applied on the HCM Extract export XML file to get the html output which when opened shows the details of the extract in a user friendly tabular format.
I made some minor tweaks to the John’s XSL script to make it more user friendly by changing some parameters and spacing.
Without much delay, let’s have a look at the tool and how we should use this tool.
Let’s take a sample Extract export XML file and see how it looks.
We will consider an existing extract for this purpose and let’s see how we export the XML file for an extract.
Navigate to My Client Groups > Extract Definitions and search for the extract.
Click on the Export button to export the extract to XML.
HCM Extract Export XML will look like below:
It is hard to read through this XML file to check all attributes and the flags associated with the attributes , advanced filters, fast formulas and dbi name.
Now, we will use the XSL Transformation tool to transform the Exported XML file to an html file.
We will use the free XSL Transformation tool online https://www.freeformatter.com/xsl-transformer.html
Now, let’s input the Exported XML and XSL file (John’s XSL file attached at the end of the article) and click Transform. You can either copy paste the XML and XSL or browse for the files and transform it.
It will open up a new window with the transformed output file.
Copy paste it onto Notepad++ and save it as Extract_Name.html (SM_Demo_V1.html)
Now, Let’s open the html file and check how it displays the output.
Overall this is a cool way of reading through the extract without importing the extract to an instance.
Tip: We can use this html view to compare changes to an extract between different instances. As it extracts attribute and flag level information, this can be used to compare and migrate changes.
Download Links for Files: