Publish Chart Of Account Hierarchies Completed With Error For A Large Hierarchy (Doc ID 1474361.1)

Last updated on DECEMBER 04, 2013

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


When attempting to publish a large account hierarchy defined for one of the segments of the Chart of Accounts, the process ends in error.

ERROR
-----------------------

The log file of the program Publish Account Hierarchies shows the following information:


addTreeVersionToOutline(): Building dimension Cost Center...
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 DOES NOT exist in FND Tree UI. And so there are other errors inbuilding. Refer to the Exception.
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


The issue can be reproduced with the following steps:
1. Define a large tree for a segment
2. Submit the program Publish Account Hierarchies to publish the tree to the cube

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