Account Hierarchy Data Issue

(Doc ID 2315144.1)

Last updated on OCTOBER 08, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Sales - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.11.1.0 version, Analytics

There are many accounts in the production instance which are having multiple hierarchy tree. Ideally, they would want to merge all multiple hierarchy trees into one.

In this instance, Account 100000072768018 is a child of Account 100000117862065 which is a child of Account 100000118051191. But the data is aligned such that it's showing in multiple lines. Also, the account hieararchy is duplicating too
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms