Unable To Publish Account Hierarchy Imported Through FBDI (Doc ID 2612192.1)

Last updated on JUNE 26, 2023

Applies to:

Symptoms

On : 11.13.19.07.0 version, Set Up FCR-Define Ledgers

Unable to Publish Account Hierarchy for Reporting

An additional hierarchy has been created. The hierarchy has been published but it fails with below errors:

ERROR
-----------------------
######################## publishTreeVersions(): end incremental build for dimension Cost Centre start at Wed Oct 09 11:31:22 UTC 2019 ###########################
publishTreeVersions(): Exception during Incremental Build :: com.essbase.api.base.EssException: Cannot end incremental build. Essbase Error(1060053): Outline has errors
publishTreeVersions(): Checking if this is because of duplicate nodes added in FND Tree UI
=======================Error File Print Start ==================
\Outline verification errors:
\\Member [101001] has multiple copies of same shared member in at least one stored hierarchy. See other messages for which members and which hierarchies.
........
\\This stored hierarchy has multiple copies of same shared member [Cost_Centre_Main-Cost_Centre_Main_v1]. Remove extra member or change hierarchy to be Dynamic.
=======================Eror File Print End ==================

STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Create an account hierarchy tree version with identical values like Ops, OPS using FBDI file(ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm)
2. Upload the CSV file generated and run Ess process "Import Segment Values And Hierarchies"
3. It completes successfully and submits the hierarchy publish job and it shows the error message as shown above

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.