My Oracle Support Banner

Hierarchy update from Enterprise Data Management Cloud Service not working (Doc ID 2649050.1)

Last updated on FEBRUARY 16, 2024

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Oracle Enterprise Data Management Cloud Service - Version 18.01.42 and later
Information in this document applies to any platform.


On : version, Financial Reporting and Analysis

Hierarchy update from Enterprise Data Management Cloud Service (EDMCS) to Fusion ERP (Enterprise Resoource Planning) errors.



Per process log,

“…at oracle.apps.fnd.applcore.trees.service.applicationModule.TreeServiceImpl.flattenMaster(
    at oracle.apps.fnd.applcore.trees.service.applicationModule.TreeSerColumn Flattening  failedORA-20107: Because the dest-parent node, 983D79D537DC1FB0E05312371A0AD13F, is not found, the value node, 985354DB0E20B4D3E05312371A0A5964, with pk values (16024, <SEGMENT NAME>, , , ) cannot be added into tree (GL_ACCT_FLEX, <SEGMENT NAME>, 95837E50BC3CBA25E05312371A0A08E2).
ORA-06512: at "FUSION.FND_TREE_UTILS_PVT", line 4808
ORA-06512: at line 1

The issue can be reproduced with the following steps:

  1. User made changes in one of the COA segment Tree like Natural Account or Company,etc..
  2. Load Hierarchies from EDMCS to Oracle Fusion ERP
  3. Run Process Account Hierarchies successfully
  4. Hierarchies (with desired changes) are not updated to Essbase cubes. The setup for Hierarchies in Fusion remains uncompleted and does not match with the GlSegmentHierInterface file (loaded from EDMCS).




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

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