Search Results range_attribute




Overview
Explore in AI Chat

Overview

The FND_FLEX_VALUE_HIER_ALL table is a core data object within the Application Object Library (FND) of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central repository for storing hierarchical relationships between values in a key flexfield segment. Specifically, it defines parent-child relationships where a parent value can represent a range of child values, enabling the creation of summary levels and roll-up reporting structures. This table is fundamental for implementing value hierarchies, which are critical for financial reporting, account roll-ups, and organizational structuring across various EBS modules like General Ledger (GL) and Assets (FA).

Key Information Stored

The table's primary key, as documented, is a composite of six columns that uniquely identify a hierarchical range. The most critical columns include:

  • FLEX_VALUE_SET_ID: Links the hierarchy entry to its specific flexfield value set (FND_FLEX_VALUE_SETS).
  • PARENT_FLEX_VALUE: The higher-level, summary value in the hierarchy.
  • RANGE_ATTRIBUTE: A key column that defines the type of relationship. It typically indicates whether the child values are specified as a single value ('C') or a contiguous range ('P' for parent-defined or 'R' for child-defined). This is central to the user's search context.
  • CHILD_FLEX_VALUE_LOW and CHILD_FLEX_VALUE_HIGH: Define the lower and upper bounds of the child value range. For a single child value, these columns hold the same value.
  • HIERARCHY_LEVEL: Indicates the depth or level of the parent value within the overall hierarchy tree.

Common Use Cases and Queries

This table is primarily accessed for hierarchical reporting and validation. A common use case is generating a roll-up report for a chart of accounts, where summary accounts (parents) aggregate transactions from detailed accounts (children). Developers often query this table to programmatically navigate hierarchies or validate parent-child relationships. A sample query to find all child ranges for a specific parent value, filtered by the RANGE_ATTRIBUTE, would be:

SELECT child_flex_value_low, child_flex_value_high, range_attribute
FROM apps.fnd_flex_value_hier_all
WHERE flex_value_set_id = 101
AND parent_flex_value = 'PARENT_VALUE'
AND range_attribute = 'P';

Another critical pattern is joining this table to FND_FLEX_VALUES to retrieve the descriptive names of the parent and child values for user-facing reports.

Related Objects

The table has a direct relationship with the core flexfield value tables via its primary and foreign keys. Key related objects include:

  • FND_FLEX_VALUE_SETS: Joined via FLEX_VALUE_SET_ID. This is the master table for value set definitions.
  • FND_FLEX_VALUES: The PARENT_FLEX_VALUE, CHILD_FLEX_VALUE_LOW, and CHILD_FLEX_VALUE_HIGH columns contain values that correspond to FLEX_VALUE in this table for the same FLEX_VALUE_SET_ID. This relationship is used to get the meaning and enabled status of the values.
  • FND_FLEX_HIERARCHIES: While not explicitly shown in the provided metadata, this table often works in conjunction with FND_FLEX_VALUE_HIER_ALL to define the overall hierarchy structure.

The documented primary key constraint, FND_FLEX_VALUE_HIER_ALL_PK, enforces the uniqueness of the combination of these six columns, ensuring data integrity for hierarchical definitions.