Using Parent-Child Hierarchy values defined for COA segments in OTBI

GopiKAutomus

Summary

Using Parent-Child Hierarchy values defined for COA segments in OTBI

Content

We have Parent- child hiearchies for the COA segment values especially for BSV, Natural account, Department.  These are available in OTBI as well.  There may be multiple account hierarchies in the system.  We would like to know if we select any of the Parent values, will the results show based on all the Chile values underneath in OTBI?

Also, how can we achieve the same in BI Publisher reports as well?

 

Thanks

GK

Arun Raj

Hi,

You can use FND_TREE_NODE and fnd_tree_version_vl tables to get the hierarchy data in BI report.

Thanks,

Arun