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:
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM