Search Results major_value

Overview

FII_ASSET_CAT_MAJOR_V is a lightweight Oracle EBS database view owned by the APPS schema. It exposes a distinct list of asset category major classifications sourced from the FII_FA_CAT_DIMENSIONS table, which is part of the Oracle Financials Intelligence / Enterprise Performance Foundation (EPF) dimensional model used to support Fixed Assets analytics and reporting. The view presents two columns only: an internal identifier (ID) and a human-readable major category value (VALUE).

Its principal role is to supply a normalized, de-duplicated value set for the "major" level of the fixed asset category dimension. Because it resolves the underlying dimension surrogate key (MAJOR_ID) to a business-friendly label (MAJOR_VALUE), the view is well suited to acting as a value set source for concurrent program parameters, Oracle Forms LOVs, BI Publisher data definitions, and ad hoc reporting against the Fixed Assets subject area. Users searching for the term "major_value" typically encounter this view when building list-of-values queries or joining analytic fact data back to a readable category description.

Underlying Base Objects

The view is defined over a single base object, FII_FA_CAT_DIMENSIONS. The ETRM metadata records the view text explicitly as:

• SELECT DISTINCT major_id id, major_value value FROM fii_fa_cat_dimensions

FII_FA_CAT_DIMENSIONS is a dimension table in the FII (Financials Intelligence) schema family. Each row represents a combination of asset category attributes at different hierarchical levels — major, minor, and detail — along with the surrogate keys that link those levels to the fact tables in the Fixed Assets analytic schema. Because a single major category appears on many rows (one for each minor/detail combination beneath it), the view applies DISTINCT to collapse the set to one row per major category.

The ETRM metadata documents no additional referenced base objects, and the view performs no joins, aggregations, or filters beyond the implicit distinctness requirement. Consequently it carries no dependency on fixed asset transaction tables such as FA_ADDITIONS or FA_BOOKS.

Key Columns

• ID — Aliased from MAJOR_ID. This is the surrogate key identifying the major category. It is the value that should be stored or compared when joining to other FII dimension or fact tables, and it is typically the hidden "return value" in an LOV.
• VALUE — Aliased from MAJOR_VALUE. This is the descriptive display name of the major asset category as maintained in the FII dimensional model. It is the value presented to end users in LOV lists, parameter prompts, and report headings.

Both columns are derived directly from the base table without transformation, apart from the renaming to the generic ID/VALUE convention commonly used for Oracle EBS value set definitions.

Common Use Cases and Queries

The most frequent use is as the source query behind a value set for a concurrent program or report parameter that requires a major asset category. A typical validation query is:

• SELECT value, id FROM apps.fii_asset_cat_major_v ORDER BY value

To resolve a major category description from an ID already stored elsewhere:

• SELECT value FROM apps.fii_asset_cat_major_v WHERE id = :major_id

For reporting that joins Fixed Assets analytic data to a readable category label, the view is joined on its ID column against the corresponding MAJOR_ID in the FII dimension or fact tables, avoiding repeated row fan-out that would occur if FII_FA_CAT_DIMENSIONS were queried directly. Because the view contains only distinct majors, it is also convenient for populating report parameter LOVs, driving BI Publisher lexical parameters, and producing summary groupings across all fixed asset categories. Standard EBS security applies: the APPS synonym must be accessible to the invoking responsibility, and the FII schema objects must be compiled and valid in the target environment.