Crawling The HR Org Tree
Looking for a nice user friendly way to display the Oracle HR Organization Tree. Here is a simple piece of code that will crawl the HR Org Tree and produce a report of the selected org that can easily be imported into Excel. Using a recursive call to the subroutine print_node it follows each branch of the org tree to its end printing a row in the output file for each node.
You are welcome to use or modify it for free on the understanding that my company Solution Support Services and I give no guarantee on its fitness for purpose and provide no warranty and accept no liability.