Search Results minor_id

Overview

The view APPS.FII_ASSET_CAT_MINOR_V is a lightweight Oracle E-Business Suite (EBS) database object that exposes the minor (detail-level) values of asset category dimensions used by the Oracle Financial Intelligence / Enterprise Performance Foundation (FII/EPF) analytics infrastructure. It is a presentation-layer view whose sole purpose is to present a normalized, de-duplicated list of minor category dimension members so that downstream reports, integrations, and analytic configurations can reference asset categories by a consistent identifier and descriptive value.

Within Oracle EBS 12.1.1 and 12.2.2, the FII_ prefixed objects belong to the Financial Intelligence product family, which supplies the dimensional model for financial reporting, budgeting, and profitability analysis. Rather than duplicating fixed asset category data, this view projects the relevant dimension members so that they can be consumed as a validated value set — an ID and a display value — for parameter selection, mapping tables, and ETL targets.

Underlying Base Objects

According to the ETRM documentation, the view is defined as a simple, distinct projection over a single base object. The documented view text is:

• SELECT DISTINCT MINOR_ID ID, MINOR_VALUE VALUE FROM FII_FA_CAT_DIMENSIONS

The referenced base object is FII_FA_CAT_DIMENSIONS, which stores the fixed asset category dimension members in the Financial Intelligence dimensional store. The ETRM metadata records "none documented" for additional referenced base objects, confirming that FII_FA_CAT_DIMENSIONS is the only underlying source. Because the projection applies DISTINCT, the view returns one row per unique combination of MINOR_ID and MINOR_VALUE, effectively eliminating any duplicate dimension rows present in the base structure.

No joins are performed and no filter predicates are applied, so the view inherits the full row population of the minor-level members defined in the underlying dimension table. This keeps the view cheap to query and predictable in cardinality.

Key Columns

The view exposes exactly two columns, both aliased from the underlying dimension table:

• ID — aliased from MINOR_ID, this is the internal identifier (key) of the minor asset category dimension member. It is the value typically stored in foreign-key-like columns of fact or mapping tables.
• VALUE — aliased from MINOR_VALUE, this is the descriptive, user-facing name or code for the minor category member and is what end users recognize in reports and list-of-values prompts.

Because the underlying object is FII_FA_CAT_DIMENSIONS, the "minor" designation refers to the lowest level of the asset category hierarchy. Higher-level category members are generally held in companion dimension tables (for example, major and mid-level dimensions), and this view isolates only the minor tier.

Common Use Cases and Queries

The view is most often used to populate value sets for report parameters, to drive LOVs in concurrent program parameters, and to supply reference data to integration or ETL processes that map general ledger and fixed asset activity to the FII dimensional model. Typical queries include:

• SELECT id, value FROM apps.fii_asset_cat_minor_v ORDER BY value; — retrieve the full list of minor category members for a report or LOV.
• SELECT value FROM apps.fii_asset_cat_minor_v WHERE id = :p_minor_id; — resolve a stored minor ID to its display value.
• SELECT id FROM apps.fii_asset_cat_minor_v WHERE value = :p_minor_value; — look up the ID for a known category name, supporting inbound integration mappings.

Because DISTINCT is applied, results are safe to use directly in LOV and mapping contexts without additional de-duplication. As with all FII views, access is governed by the APPS schema and standard EBS responsibility-based security, and the view should be treated as read-only reference data.