Search Results minor_value

Overview

FII_ASSET_CAT_MINOR_V is a reporting view owned by the APPS schema within the Financial Intelligence (FII) product family of Oracle E-Business Suite. Its documented status is VALID across the 12.1.1 and 12.2.2 releases. The view exists to expose the minor category segment of an asset category as a simple, distinct key/value list. In FII reporting and integration flows, dimension values for asset categories must frequently be resolved to human-readable selections — for example, when populating a list of values, driving a parameter list in a concurrent program, or supplying a lookup source for an extract or dashboard. This view provides exactly that narrow slice: the unique set of minor category identifiers and their corresponding values, decoupled from the wider asset category dimension structure.

Underlying Base Objects

The view is defined over the single table FII_FA_CAT_DIMENSIONS, which stores the asset category dimension hierarchies used by Financial Intelligence. Per the documented view text, no other tables participate:

• FII_FA_CAT_DIMENSIONS — the sole documented base object, contributing both the MINOR_ID and MINOR_VALUE columns that the view projects.

Because the view text applies a DISTINCT operator to the projection, the view collapses any duplicate minor category combinations present in the base table into a single row per minor category. The view is therefore a denormalized, de-duplicated representation of one segment of the category dimension, not a joined or aggregated structure. No warehouse or interface tables are referenced by the definition.

Key Columns

The view exposes two columns, both drawn directly from FII_FA_CAT_DIMENSIONS:

• ID — aliased from MINOR_ID. This is the internal identifier for the minor category segment value. It functions as the join key when relating the view to other asset category dimension views or to fact data that stores the numeric minor category reference.
• VALUE — aliased from MINOR_VALUE. This is the display or descriptive value associated with the minor category. This is the column most commonly used for user-facing lists and report labels.

The ID/VALUE pairing follows the conventional key-value shape used throughout Oracle EBS views that feed list of values and lookup mechanisms, which simplifies consumption by forms, concurrent programs, and BI Publisher data models.

Common Use Cases and Queries

Typical scenarios include building a list of values for a minor asset category parameter, joining minor category descriptions onto extracted asset data, and validating that a required minor category value exists before an interface load runs. A representative query returning the full set of distinct minor categories is:

• SELECT id, value FROM apps.fii_asset_cat_minor_v ORDER BY value; — retrieves the complete, sorted list of minor category identifiers and values.
• SELECT value FROM apps.fii_asset_cat_minor_v WHERE id = :minor_id; — resolves a single minor category identifier to its descriptive value.
• SELECT COUNT(*) FROM apps.fii_asset_cat_minor_v; — returns the number of distinct minor categories available in the dimension source.

Because the view performs a DISTINCT over FII_FA_CAT_DIMENSIONS, queries against it return each minor category once regardless of how many asset category rows reference that value in the base table. This makes it well suited to parameter lists and lookup sources where repetition would be undesirable. For any query requiring major category or full hierarchy context, the base table FII_FA_CAT_DIMENSIONS or the companion category views should be joined instead, since FII_ASSET_CAT_MINOR_V deliberately exposes only the minor segment.