Search Results display_level




Overview
Explore in AI Chat

Overview

FII_FIN_ITEMS_V is a view owned by the APPS schema within the FII – Financial Intelligence product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The ETRM metadata for this object carries the description "No longer used." Despite this status, the view remains VALID and is still deployed in the database, meaning it can be queried but is no longer referenced by any active FII runtime logic, concurrent program, or shipped report. It exists as a legacy compatibility stub retained for backward compatibility and is scheduled to be desupported in a future release.

Functionally, the view exposes a flattened, hierarchical representation of financial reporting items derived from Oracle General Ledger's parent-child value hierarchy. It is designed to translate the raw flex value hierarchy structure into a report-oriented shape containing a row identifier, a display-level placeholder, an indentation value, a parent/child flag, and the financial item (account segment value) itself. Because the view is marked obsolete, implementers should treat it purely as reference material and should not build new dependencies on it.

Underlying Base Objects

The view is defined over a single documented base object: FND_FLEX_VALUE_NORM_HIERARCHY, aliased in the view SQL as FFVNH. This is the standard Oracle Application Object Library table that stores the parent-child hierarchy relationships between key flexfield segment values, including the range attributes that determine whether a given flex value behaves as a parent or a child node.

No other base tables or views are documented as referenced. There are no joins in the view definition — the SELECT statement projects columns exclusively from FND_FLEX_VALUE_NORM_HIERARCHY using DECODE and TO_CHAR transformations. Consequently, the granularity of FII_FIN_ITEMS_V is identical to that of its single source table: one row per normalized hierarchy entry (that is, per parent-to-child relationship record).

Key Columns

  • ROW_ID — Populated from FFVNH.ROWID. Provides the physical row identity of the underlying hierarchy record and can be used as a surrogate key when reconciling view output back to the base table.
  • DISPLAY_LEVEL — Defined as TO_CHAR(NULL). This is the column most relevant to the user search term "display_level." In this view it is deliberately hard-coded to NULL; it performs no functional role and exists only to preserve an expected column shape for historical consumers. Any report relying on a populated display level must derive it elsewhere, such as from FND_FLEX_VALUES_VL or a recursive hierarchy query against the flex value set.
  • INDENTATION — Also hard-coded to NULL. It was intended to carry the visual indent depth for tree-style reports but is non-functional in this definition.
  • PARENT_ITEM_FLAG — Computed via DECODE(FFVNH.RANGE_ATTRIBUTE, 'P', 'Y', 'C', 'N'). Returns 'Y' when the range attribute indicates a parent ('P') node and 'N' for a child ('C') node. This is the only column carrying meaningful derived logic.
  • FIN_ITEM — Populated from FFVNH.CHILD_FLEX_VALUE_LOW. Identifies the child (low-range) flex value for the hierarchy entry, effectively representing the financial reporting item.

Common Use Cases and Queries

Because the object is documented as no longer used, the primary practical scenario is impact assessment: confirming whether any custom report, interface, or personalization still references FII_FIN_ITEMS_V before decommissioning. A typical diagnostic query is a simple projection:

  • SELECT row_id, parent_item_flag, fin_item FROM apps.fii_fin_items_v WHERE parent_item_flag = 'Y';
  • SELECT fin_item, COUNT(*) FROM apps.fii_fin_items_v GROUP BY fin_item ORDER BY 2 DESC;
  • Reference-list queries against FND_VIEWS or FND_VIEW_COLUMNS to detect any dependent metadata.

Note that DISPLAY_LEVEL and INDENTATION always return NULL, so filtering or ordering by these columns is not meaningful. For any new hierarchy reporting requirement, Oracle recommends building directly against FND_FLEX_VALUE_NORM_HIERARCHY or the supported flexfield views rather than this obsolete object.