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

Last updated on FEBRUARY 16, 2024

Applies to:

Symptoms

On : 11.13.20.01.0 version, Financial Reporting and Analysis

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

ERROR

-------

Per process log,

“…at oracle.apps.fnd.applcore.trees.service.applicationModule.TreeServiceImpl.flattenMaster(TreeServiceImpl.java:1676)
    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

STEPS
-----------------------
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).
   
   
   
   

Changes

Cause

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