Publish Hierarchies Program Completed With Error: Essbase Error(1060053), GL-781270
(Doc ID 1447020.1)
Last updated on SEPTEMBER 11, 2020
Applies to:Oracle Fusion General Ledger - Version 126.96.36.199.1 and later
Oracle Fusion General Ledger Cloud Service - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
If you are a Software-as-a-Service (SaaS) customer, there are multiple sections in this document that need not be performed by you. Please log a Service Request in My Oracle Support for Oracle to do this for you.
When attempting to publish account hierarchies to publish the hierarchies to the cube and use them in balances inquiry and reporting, the ESS program launched for this purpose ends in error.
The log file shows the following information:
addTreeVersionToOutline(): Building dimension Company...
addTreeVersionToOutline(): Exception during Incremental Build :: com.essbase.api.base.EssException: Cannot end incremental build. Essbase Error(1060053): Outline has errors
addTreeVersionToOutline(): Checking if this is because of duplicate nodes added in FND Tree UI
addTreeVersionToOutline(): Duplicate nodes exist in FND Tree UI for tree version: FA Company Hierarchy and teh duplicate nodes is/are : 1359
addTreeVersionToOutline(): Main Essbase Error : Tree Version FA Company Hierarchy includes the following value 1359 more than once. This is not supported. You must change the tree version. (GL-781270)
addTreeVersionToOutline(): Known Warning with otl close :: Cannot verify cube outline. Essbase Error(1060001): NULL argument (%s) passed to ESSOTL function %s
handleIncomingTreeVersion(): END : Exception: Cannot end incremental build. Essbase Error(1060053): Outline has errors
publishTreeVersions()::: Exception occurred with building the version :Cannot end incremental build. Essbase Error(1060053): Outline has errorscom.essbase.api.base.EssException: Cannot end incremental build. Essbase Error(1060053): Outline has errors
publishTreeVersions()::: Please re-publish the Version:
The issue can be reproduced with the following steps:
1. Go to the task Publish Account Hierarchies
2. Set the ‘Publish’ flag for the tree version and save.
3. Click the Publish action button. An ESS program is submitted and ends in error.
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