Oracle Fusion Data Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Natural Accounts should be sorted and indented based on hierarchy on FRS reports

Needs Votes
49
Views
0
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

Timestamp S.I

Description (Required):

When selecting the 'Descendants' function on the 'select members' window, the natural accounts listed are not sorted based on the hierarchy nodes.

Upon creating a customized trial balance in FRS we have noticed that when using the 'Descendants' function for the natural account dimension, the hierarchy members are being listed alphanumerically and not based on the existing nodes in the hierarchy as visible in the 'View Tree Version' screen in 'Manage Account Hierarchies'.

Use Case and Business Need (Required):

The function should reflect and list the chosen hierarchy based on the existing parent-child relationships.

Since the customer has a hierarchy with thousands of members, it becomes almost impractical to analyze balances.

The information will be way easier to read and analyze if displayed based upon hierarchies nodes rather than the current ordering.

Enhancement Request / Service Request:

4
4 votes

Needs Votes · Last Updated