Search Results master_value_set_name

Overview

FII_FINANCIAL_DIMENSIONS_V is a Financial Intelligence (FII) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the set of financial dimensions that Enterprise Performance Foundation / Financial Intelligence uses to slice balances, hierarchies, and analytical reporting structures. The view consolidates dimension definitions from the FII_FINANCIAL_DIMENSIONS configuration table with level customizations and flexfield value set metadata, producing a single normalized record per registered financial dimension.

The view is primarily a metadata access layer. Rather than storing transaction facts itself, it describes the dimensions (Company, Line of Business, Financial Item, user-defined dimensions, and so on) that downstream FII reports and integrations rely on when building hierarchies, mappings, and drill-through experiences. Its most notable column for users searching on dbi_hier_top_node is DBI_HIER_TOP_NODE, which records the top (root) node of the dimensional hierarchy used by Daily Business Intelligence style hierarchy processing.

Underlying Base Objects

The documented definition references the following objects:

• FII_FINANCIAL_DIMENSIONS (FRD) — the primary configuration table holding dimension short names, master value set IDs, hierarchy top node values, and flags controlling mapping behavior.
• BISFV_LEVELS_CUSTOMIZATIONS_V (BD) — a BIS (Business Intelligence System) view supplying dimension level names, short names, descriptions, and an ENABLED indicator that is translated into the DBI_ENABLED_FLAG column.
• FND_FLEX_VALUE_SETS (FFVS) — the standard key flexfield value set table, joined via MASTER_VALUE_SET_ID to resolve the master value set name.
• FND_LOOKUP_VALUES_VL (LOOK2) — used as a fallback lookup (LOOKUP_TYPE = 'FII_LITERAL', LOOKUP_CODE = 'N/A') to supply a master value set name for dimensions without a flex value set.

The join between FII_FINANCIAL_DIMENSIONS and BISFV_LEVELS_CUSTOMIZATIONS_V is on DIMENSION_SHORT_NAME, and the view filters to a fixed list of seven registered dimensions: FII_COMPANIES, HRI_CL_ORGCC, FII_LOB, GL_FII_FIN_ITEM, ENI_ITEM_VBH_CAT, FII_USER_DEFINED_1, and FII_USER_DEFINED_2.

Key Columns

• LINE_NUMBER — a decoded ordinal (1 through 7) assigned per dimension short name, establishing a stable display sequence.
• DIMENSION_NAME / DIMENSION_SHORT_NAME — the descriptive and abbreviated identifiers of each dimension.
• DESCRIPTION — free-text description inherited from the level customizations view.
• SYSTEM_ENABLED_FLAG — indicates whether the dimension is a system-seeded dimension.
• DBI_ENABLED_FLAG — normalizes the BIS 'T'/'F' enabled indicator into standard EBS 'Y'/'N' values.
• MASTER_VALUE_SET_ID / MASTER_VALUE_SET_NAME — identifies the flexfield value set that supplies dimension members; for ENI_ITEM_VBH_CAT this is derived through ENI_VALUESET_CATEGORY.GET_FLEX_VALUE_SET_ID.
• DBI_HIER_TOP_NODE / DBI_HIER_TOP_NODE_ID — the name and internal identifier of the hierarchy's top node, used to anchor hierarchy traversals.
• ALLOW_UPDATE_MAPPING_FLAG — 'N' for GL_FII_FIN_ITEM, 'Y' otherwise, controlling whether mapping maintenance is permitted.
• INCL_MASTER_VS_LEAF_NODES_FLAG — governs whether both master and leaf nodes participate in reporting.

Common Use Cases and Queries

Typical usage includes validating dimension configuration before hierarchy loads, resolving the top node for a dimension, and populating LOVs or setup pages that present available dimensions.

To list all enabled dimensions:

• SELECT line_number, dimension_short_name, dimension_name, dbi_enabled_flag FROM fii_financial_dimensions_v ORDER BY line_number;

To retrieve the hierarchy top node for a specific dimension:

• SELECT dimension_short_name, dbi_hier_top_node, dbi_hier_top_node_id FROM fii_financial_dimensions_v WHERE dimension_short_name = 'FII_COMPANIES';

To inspect value set resolution and mapping privileges:

• SELECT dimension_short_name, master_value_set_name, allow_update_mapping_flag FROM fii_financial_dimensions_v WHERE master_value_set_name IS NOT NULL;