My Oracle Support Banner

GLDRMLDR: Load Segment Values and Hierarchies error ERROR: The value for Summary Flag cannot be updated (Doc ID 2661224.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Hyperion Data Relationship Management - Version and later
Information in this document applies to any platform.


When attempting to run GLDRMLDR: Load Segment Values and Hierarchies the following error occurs.

ERROR: The value for Summary Flag cannot be updated. Please reset it to its original value.
27-Feb-XX 04:03:36 :- Summary differs: Old Value=N, New Value=Y

This issue can be reproduced anytime a change in hierarchy is made in Hyperion Data Relationship Management (DRM) changing a child value
to a parent value or a parent value to a child value.

In DRM terms:
On the E-Business Suite (EBS) General Ledger (GL) side the problem is stated in the error: The value for Summary Flag cannot be updated.

It is not immediately obvious from the error though exactly what needs changing back on the DRM side. The root cause of the error on the DRM side is that the OracleGL.Parent property for the node given in the error was set to 'No' in the past because it was a leaf node (i.e. it had no children and did not have the possibility to add children) but has now changed to 'Yes' (i.e. it is now a limb node that may or may not have children).

The OracleGL.Parent property value is dynamically assigned based upon the value of the core.leaf property of the node in DRM such that:
1. When core.leaf = True (i.e. the node does not have children) then OracleGL.Parent = No.
2. When core.leaf = False (i.e. the node is a limb node and either does have children or has the possibility of children being added) then OracleGL.Parent = Yes.

The error on the EBS GL side is indicating that the node has changed from a leaf node to a limb node or vice versa in DRM.


 A child segment value has been changed to a parent value.


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.