Results for “range_attribute”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_FLEX_VALUE_HIER_ALL is an Oracle E-Business Suite table owned by the APPLSYS schema and registered under the FND — Application Object Library product. It stores all value hierarchy ranges defined for a key flexfield segment. In Oracle EBS, key flexfields such as the Accounting Flexfield, Asset Key Flexfield, and Item Key Flexfield rely on value sets, and value sets may optionally support hierarchical parent-child relationships. This table records those relationships in range form, where a parent flex value spans a contiguous range of child flex values rather than enumerating individual child values one by one. The table exists in both 12.1.1 and 12.2.2 and is fundamental to hierarchical security, rollup reporting, and parent-value summarization in General Ledger and related subledgers.

The heuristic Data Vault classification mined from the foreign key structure is standalone. From a modeling perspective, this suggests the table behaves as an independent reference entity rather than participating in a classic hub-link-satellite topology with other documented objects. The composite primary key FND_FLEX_VALUE_HIER_ALL_PK is defined across FLEX_VALUE_SET_ID, PARENT_FLEX_VALUE, RANGE_ATTRIBUTE, CHILD_FLEX_VALUE_LOW, CHILD_FLEX_VALUE_HIGH, and HIERARCHY_LEVEL, which together enforce uniqueness of each hierarchy range row.

Key Information Stored

The most significant columns are:

• FLEX_VALUE_SET_ID — Identifies the flexfield value set to which the hierarchy belongs; a primary key component and the principal join key.
• PARENT_FLEX_VALUE — The parent value in the hierarchy; the value whose children are described by the range on this row.
• RANGE_ATTRIBUTE — Qualifies the type or purpose of the range relationship; a primary key component and the column matched by the user's search term.
• CHILD_FLEX_VALUE_LOW — The lower bound of the child value range.
• CHILD_FLEX_VALUE_HIGH — The upper bound of the child value range.
• HIERARCHY_LEVEL — Indicates the depth or level of the parent within the hierarchy structure.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Define the effective date range during which the hierarchy range is valid.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking creation and modification.

The surrogate primary key is the composite FND_FLEX_VALUE_HIER_ALL_PK spanning six columns. Business-key candidates are effectively the same set of columns, since no separate unique index is documented beyond the primary key. The 13-column physical schema is consistent across 12.1.1 and 12.2.2.

Common Use Cases and Queries

Typical scenarios include validating parent-child rollups for the Accounting Flexfield, reproducing hierarchy summaries for financial reporting, and auditing the effective dates of hierarchy ranges. A common query pattern filters by value set and parent:

• SELECT parent_flex_value, child_flex_value_low, child_flex_value_high, hierarchy_level FROM fnd_flex_value_hier_all WHERE flex_value_set_id = :p_value_set_id AND parent_flex_value = :p_parent;
• Join to FND_FLEX_VALUES to resolve parent and child descriptions for reporting.
• Filter on START_DATE_ACTIVE and END_DATE_ACTIVE to obtain only currently effective ranges.

Related Objects

The principal related objects (not exhaustive) include:

• FND_FLEX_VALUES — joined on FLEX_VALUE_SET_ID and FLEX_VALUE to resolve parent and child value names.
• FND_FLEX_VALUE_SETS — joined on FLEX_VALUE_SET_ID to identify the owning value set.
• FND_FLEX_VALUES_TL — provides translated descriptions of value set values.
• FND_ID_FLEX_SEGMENTS — identifies the segment to which the value set and hierarchy apply.
• GL_CODE_COMBINATIONS — consumes hierarchy rollups for accounting flexfield summarization.
• FND_FLEX_VALIDATION_TABLES and related FND flexfield validation objects that depend on value set hierarchy definitions.

Oracle Proprietary, Confidential Information — Legal Notices apply.