Home » Developer & Programmer » Reports & Discoverer » CHART OF ACCOUNTS HIERARCHY
CHART OF ACCOUNTS HIERARCHY [message #272229] Thu, 04 October 2007 04:57 Go to next message
fusion007
Messages: 11
Registered: September 2007
Junior Member
Hi...
I want to create a Disco report to list all parents with the child values underneath them.
For example, the top parent level might be TOTAL and underneath that we may have 4 other parents say ABCD, EFGH, IJKL, MNOP and underneath that we may well have more parents and child cost centres.
What I want to be able to do is list the top level TOTAL then underneath have ABCD under which should the other parent codes and child codes. Then the same for EFGH etc. Example:

TOTAL

- ABCD
1234
5678
- WXYZ
9999
6789

- EFGH
8756
1257
7667
- MHSA
5567
3487

etc etc. I hope you understand what I'm trying to do. Basically have a hierarchy tree.

There is one view that has the required data FND_FLEX_HIERARCHIES_VL.

I'd be grateful for any advice please. I'm using Disco version 4.1.

Thanks
Re: CHART OF ACCOUNTS HIERARCHY [message #272370 is a reply to message #272229] Thu, 04 October 2007 14:13 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Hi,
You have to do this in SQL (create a view), Discoverer can't do this. You can do it using connect by prior functionality, see the SQL reference.
Regards,
Sabine
Re: CHART OF ACCOUNTS HIERARCHY [message #274816 is a reply to message #272370] Wed, 17 October 2007 04:53 Go to previous messageGo to next message
fusion007
Messages: 11
Registered: September 2007
Junior Member
Thanks Sabine.

Has anyone done anything similar before?

Regards
Re: CHART OF ACCOUNTS HIERARCHY [message #274933 is a reply to message #274816] Wed, 17 October 2007 14:23 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
I have. But it will be a lot of fun finding it out yourself Wink
Re: CHART OF ACCOUNTS HIERARCHY [message #275063 is a reply to message #274933] Thu, 18 October 2007 03:51 Go to previous message
fusion007
Messages: 11
Registered: September 2007
Junior Member
Thanks Sabine Razz

But if are feeling generous and would like to help out a novice I'd really appreciate it. You can be my guru! Cool
Previous Topic: Oracle Discoverer Question
Next Topic: Maximum Record per page 1
Goto Forum:
  


Current Time: Wed Dec 07 04:51:23 CST 2016

Total time taken to generate the page: 0.08163 seconds