Search Results fnd_flex_value_children_v




Overview
Explore in AI Chat

Overview

FND_FLEX_VALUE_CHILDREN_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, residing in the Application Object Library (FND) product. It exposes the parent-child relationships that exist within Oracle Flexfield value sets, resolving each child (detail) value against the normal hierarchy range within which it falls. Its principal function is to translate the range-based definition of a parent value into an explicit list of the child values that belong to it, which is essential where standard Flexfield hierarchy APIs return only ranges rather than the discrete values required for reporting and integration.

The view is widely used in Financials, Human Resources, and Supply Chain reporting where segment values are organized into parent roll-up structures — for example cost center hierarchies, account roll-ups, and summary accounts. Because reporting tools must often present data at the lowest level and aggregate upward, this view supplies the missing link between a summarized parent value and its constituent details.

Underlying Base Objects

Per the documented view text, FND_FLEX_VALUE_CHILDREN_V is constructed from three referenced objects, joined on FLEX_VALUE_SET_ID:

The view relies on the FORMAT_TYPE of the value set to decide the comparison method: numeric values are compared using FND_NUMBER.CANONICAL_TO_NUMBER; date and time values ('D', 'T') are converted with TO_DATE using the MAXIMUM_SIZE-driven format mask; and all other types use a plain string BETWEEN comparison. The final filter requires that summary parents (SUMMARY_FLAG = 'Y') align with RANGE_ATTRIBUTE = 'P', and detail children (SUMMARY_FLAG = 'N') align with RANGE_ATTRIBUTE = 'C'.

Key Columns

  • FLEX_VALUE_SET_ID — identifies the value set to which the value belongs; the join key across all three sources.
  • PARENT_FLEX_VALUE — the summarized parent value that acts as the roll-up node.
  • FLEX_VALUE — the child (detail) value that falls within the parent's defined range.
  • DESCRIPTION — the descriptive text associated with the child value.
  • SUMMARY_FLAG — indicates whether the value is a parent/summary value ('Y') or a detail value ('N').

Common Use Cases and Queries

The view is typically used to expand parent roll-up values into detailed values, to build hierarchy reports, or to validate whether a specific account resides beneath a given parent.

Listing of each child under a given parent:

SELECT flex_value_set_id,
       parent_flex_value,
       flex_value,
       description
FROM   apps.fnd_flex_value_children_v
WHERE  parent_flex_value = :parent_value
ORDER  BY flex_value;

Determining the parent (or parents) for a specific detail value:

SELECT parent_flex_value
FROM   apps.fnd_flex_value_children_v
WHERE  flex_value = :child_value
AND    flex_value_set_id = :value_set_id;

Because the view performs type-sensitive range resolution at runtime, queries on large hierarchies should filter by FLEX_VALUE_SET_ID to constrain the value sets scanned, avoiding full-table evaluation of the BETWEEN predicates.