Publish Hierarchies Program Completed With Error: Essbase Error(1060053), GL-781270
Last updated on DECEMBER 03, 2014
Applies to:Oracle Fusion General Ledger - Version 22.214.171.124.1 and later
Oracle Fusion General Ledger Cloud Service - Version N/A 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.
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