How To Find Duplicate Node in a Particular Version of Account Hierarchy (Doc ID 2187491.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

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

Goal

On : 11.1.11.1.0 version, Set Up FCR-Define Financial Reporting Structures

Publish Hierarchy errors out with below error message having duplicate parent value.

######################## publishTreeVersions(): duplicate parent inserted with cubeId= 300000001090011 ,valueSetID = 51262 ,treeCode = Account NEI, version =36A68EE30DC4FAD4E053861F230AFE14, columnName = SEGMENT2...####
publishTreeVersions(): Exception :: Cannot open cube outline. Essbase Error(1060053): Outline has errors
publishTreeVersions(): Executing cmd:alter database 'NEI'.db unlock all objects
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application 'NEI' enable connects
publishTreeVersions(): Result:true
publishTreeVersions()::: Building/deleting versions for the cube failed with Exception: Cannot open cube outline. Essbase Error(1060053): Outline has errors...com.essbase.api.base.EssException: Cannot open cube outline. Essbase Error(1060053): Outline has errors
 

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