Publish Hierarchies Program Completed With Error: Essbase Error(1060053), GL-781270

(Doc ID 1447020.1)

Last updated on DECEMBER 03, 2014

Applies to:

Oracle Fusion General Ledger - Version 11.1.1.5.1 and later
Oracle Fusion General Ledger Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 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:

ERROR
-----------------------
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.

Cause

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