PublishHierarchyVersions Error (Doc ID 2099080.1)

Last updated on MAY 21, 2020

Applies to:

Symptoms

On: Financial Reporting and Analysis

ACTUAL BEHAVIOR
---------------
When publishing new parent value in the tree hierarchy from the Publish Account Hierarchies UI, the following error occurs.

ERROR MESSAGE
-----------------------------
PublishHierarchyVersions: Error:: One or more versions did not get published successfully for Chart Of Account: XXXXX INSTANCE and Segment XXXXX NodeForUDAs(): Profile Option - Display Only Segment Value Description in The Cube Alias? is set to Yes, Duplicate Aliases are existing under the Segment XXXXX Hence terinating the program, please correct below values and re-run the program. Please note that the uniqueness check is done for the first 80 characters for the member descriptions that is because of Essbase restriction only 80 characters are allowed for aliases.
Releasing Root AM...

EXPECTED BEHAVIOR
-----------------------
The tree should be published with new parent value

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Publish Account Hierarchies UI
2. Check the Publish Flag
3. Verify the Tree in Account Inspector/FRS

Cause

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