My Oracle Support Banner

PublishHierarchyVersions Error (Doc ID 2099080.1)

Last updated on FEBRUARY 13, 2025

Applies to:

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

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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