Search Results fii_user_defined_1

Overview

APPS.FII_FINANCIAL_DIMENSIONS_V is a reporting and integration view in Oracle E-Business Suite (12.1.1 and 12.2.2) that exposes the configuration of the financial dimensions used by Oracle Financials Intelligence / Enterprise Performance Foundation (FII) and related analytical engines. Rather than querying the base configuration table directly, the view consolidates the dimension registration metadata with level customizations, flex value set definitions, and lookup translations into a single, presentation-ready result set. Each row describes one financial dimension—such as company, chart of accounts organization, line of business, financial item, and user-defined dimensions—together with its sequence, display name, value set binding, and enablement flags.

The view plays a central role wherever the application must enumerate the available financial dimensions in a stable, ordered manner, for example when populating dimension pickers, driving data-loading routines, or generating hierarchy and mapping setups. The search term "fii_lob" corresponds to the FII_LOB dimension, which is assigned line number 3 in this view's decode logic.

Underlying Base Objects

The view is defined over four referenced objects:

• FII_FINANCIAL_DIMENSIONS (aliased frd) — the primary driver table holding each registered dimension, its short name, system-enabled flag, DBI-enabled flag, master value set identifier, DBI hierarchy top node and node identifier, and the include-master-versus-leaf-nodes flag.
• BISFV_LEVELS_CUSTOMIZATIONS_V (aliased bd) — a customization view supplying the dimension level name, short name, description, and enabled indicator, joined on frd.dimension_short_name = bd.dimension_level_short_name.
• FND_FLEX_VALUE_SETS (aliased ffvs) — the key flexfield value set definition, outer-joined to resolve the master value set name.
• FND_LOOKUP_VALUES_VL (aliased look2) — the lookup view, constrained to lookup_type = 'FII_LITERAL' and lookup_code = 'N/A' to supply a literal "N/A" meaning when no value set name is available.

The view restricts output to seven recognized dimension short names: 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 — ordinal position derived from DECODE on dimension_short_name; FII_LOB yields 3.
• DIMENSION_NAME / DIMENSION_DISPLAY_NAME — the level name from the customization view, used for display.
• DIMENSION_SHORT_NAME — internal identifier used throughout FII processing.
• DESCRIPTION — descriptive text for the dimension.
• SYSTEM_ENABLED_FLAG — indicates whether the dimension is enabled at system level.
• DBI_ENABLED_FLAG — enablement for DBI processing; for ENI_ITEM_VBH_CAT it is taken directly from frd.dbi_enabled_flag, otherwise derived from bd.enabled ('T' becomes 'Y').
• MASTER_VALUE_SET_ID / MASTER_VALUE_SET_NAME — the value set bound to the dimension, with special handling for ENI_ITEM_VBH_CAT via ENI_VALUESET_CATEGORY.GET_FLEX_VALUE_SET_ID.
• DBI_HIER_TOP_NODE / DBI_HIER_TOP_NODE_ID — the top node of the DBI hierarchy for the dimension.
• ALLOW_UPDATE_MAPPING_FLAG — 'N' for GL_FII_FIN_ITEM, otherwise 'Y'.
• INCL_MASTER_VS_LEAF_NODES_FLAG — controls whether master or leaf nodes are included.

Common Use Cases and Queries

Typical usage includes verifying dimension registration, auditing value set assignments, and retrieving the ordered dimension list for a given implementation. To locate the line of business dimension specifically:

SELECT line_number, dimension_name, dimension_short_name, dbi_enabled_flag, master_value_set_name
FROM apps.fii_financial_dimensions_v
WHERE dimension_short_name = 'FII_LOB';

To list all enabled dimensions in display order:

SELECT line_number, dimension_display_name, master_value_set_name
FROM apps.fii_financial_dimensions_v
WHERE system_enabled_flag = 'Y'
ORDER BY line_number;

Because the view already resolves value set names and enablement flags, it is preferred over direct queries against FII_FINANCIAL_DIMENSIONS for reporting and integration purposes.