How to create an OTBI Report to display GL Parent/Child values ?

Summary:

How to create an OTBI Report to display GL Parent/Child values ?

Content (please ensure you mask any confidential information):

Hello

I would like to have a Chart of Accounts that includes Parent/Child values. I already reviewed the following note and I applied the action plan, however not all the child values appear on the report.

I am looking something similar to manage account hierarchy

I think the table fnd_tree_node does not have all the child values

Thanks

Version (include the version you are using, if applicable):

R13

How To Find The Parent and Child Node Values In GL Account Hierarchy (Doc ID 2035391.1)