Results for “child_flex_value_id”

5 results




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

Overview

The FII_LOB_HIERARCHIES table is a core reference object within the Oracle EBS Financial Intelligence (FII) product family. It stores the child-parent relationships that define line of business (LOB) hierarchies, providing the structural backbone used by financial intelligence reporting, consolidation, and analytical processes. Each row represents a relationship edge between a parent LOB and a child LOB, together with the flex value identifiers and flex value set identifiers that map those LOB nodes to their underlying accounting flexfield definitions. The table is owned by the FII schema and is marked VALID in the documented ETRM repository for EBS 12.1.1 and 12.2.2.

The heuristic Data Vault classification mined from the foreign key structure is standalone. This should be treated as a modeling suggestion rather than a normative declaration: the table contains both descriptive hierarchy attributes and edge-relationship semantics, so depending on warehouse design it may be modeled as a link (parent-child relationship) or as a satellite when flattened against a LOB hub. The presence of a single documented foreign key, LEVEL_ID to MSD_LEVELS, is what drives the standalone classification.

Key Information Stored

The table exposes 26 columns. The most significant fall into three groups: hierarchy identifiers, flexfield mappings, and audit columns.

Common Use Cases and Queries

Typical usage centers on hierarchical reporting and roll-up of financial results across lines of business. Analysts join this table to fact data keyed by LOB to aggregate amounts at each ancestor level, and to flatten multi-level hierarchies into denormalized reporting structures.

  • Retrieving direct children of a given LOB: SELECT CHILD_LOB_ID, CHILD_FLEX_VALUE, CHILD_LEVEL FROM FII_LOB_HIERARCHIES WHERE PARENT_LOB_ID = :p_lob_id.
  • Identifying leaf LOBs for granular reporting: SELECT CHILD_LOB_ID FROM FII_LOB_HIERARCHIES WHERE IS_LEAF_FLAG = 'Y'.
  • Level-scoped expansion: filtering by PARENT_LEVEL or CHILD_LEVEL to constrain a hierarchy walk to a specified depth.
  • Cross-referencing flex values with GL code combinations via PARENT_FLEX_VALUE_ID and CHILD_FLEX_VALUE_ID for reconciliation against the chart of accounts.
  • Sort-ordered sibling presentation using NEXT_LEVEL_LOB_SORT_ORDER.

Related Objects

  • MSD_LEVELS — referenced through FII_LOB_HIERARCHIES.LEVEL_ID = MSD_LEVELS.LEVEL_ID; defines the hierarchy level for each relationship row.
  • FII_LOB_HIERARCHIES_U1 — the unique index on (PARENT_LOB_ID, CHILD_LOB_ID), enforcing uniqueness of hierarchy edges.
  • FND_FLEX_VALUES and FND_FLEX_VALUE_SETS — the underlying flex value and value set definitions that PARENT_FLEX_VALUE_ID, CHILD_FLEX_VALUE_ID, and the associated value set identifiers resolve against.
  • Other FII-lineage tables in the FII schema that consume LOB membership for financial consolidation and dimensional analysis.
  • GL code combination objects — joined via flex value identifiers when mapping LOB nodes to accounting combinations for GL-level reporting.