FND_FLEX_VALUE_NORM_HIERARCHY And FND_FLEX_VALUE_HIERARCHIES Out Of Sync (Doc ID 761761.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.0 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

Hierarchy moves on approximately 200 cost center segment values was performed. 
This was performed from the System Administrator Responsibility --> Validation --> Values --> Valueset --> Move Child Ranges.

After this activity is performed there is a data discrepancy in the FND_FLEX_VALUE_NORM_HIERARCHY table as the RANGE_ATTRIBUTE column is not updated correctly on some of the parent segments to "P."  It is reflecting a value of "C."

This causes reports to fail.

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