GL Hierarchy For Discoverer reporting
Do you or your client have the need to report on GL balances using the Account segment hierarchies?
The only way users can utilize the GL segment hierarchies is through FSG reporting and some other products such as DBI and EPF.
Each segment in GL accounting flexfield can have one or multiple hierarchies and the hierarchies are defined as parent child relationship in the FND_FLEX_NORM_HIERARCHY table. Because of the nature of the way these hierarchy is defined in GL it cannot be directly consumed for Discoverer reporting.
To take advantage of these hierarchies in Discoverer, the following solution flattens the hierarchies in one go and the flattened hierarchy can then be mapped to Discoverer hierarchies. Once this is established, users can truly benefit from Drilling down and rolling up feature of discoverer hierarchy and I have seen users just love this feature. I am sure this can be adapted to OBIEE too.
Here is the code and documentation
