Search Results major_value

Overview

FII_ASSET_CAT_MAJOR_V is a valid database view owned by the APPS schema within the FII (Financial Intelligence) product family. In Oracle EBS 12.1.1 and 12.2.2, Financial Intelligence supplies the dimensional infrastructure that supports asset-related analytics, reporting, and data warehouse style aggregations for Oracle Assets. This particular view exposes the major category segment — the highest-level classification of a fixed asset category — as a simple, denormalized value list.

The view is deliberately narrow in scope. Rather than presenting the full asset category hierarchy, it isolates only the major category dimension, returning one distinct row per major category identifier. This makes it a lightweight lookup mechanism for reporting tools, List of Values (LOV) definitions, concurrent program parameters, and integration mappings that need to resolve or enumerate major asset category values without querying the broader dimension table.

Underlying Base Objects

The view is defined over a single base object: the table FII_FA_CAT_DIMENSIONS. The documented view text is:

• SELECT DISTINCT MAJOR_ID ID, MAJOR_VALUE VALUE FROM FII_FA_CAT_DIMENSIONS

FII_FA_CAT_DIMENSIONS stores the dimensional breakdown of Oracle Assets categories along the segments that Financial Intelligence uses for analysis. Because the view applies DISTINCT to the two projected columns, it collapses the potentially repetitive major category entries held in the dimension table into a unique set of identifier/value pairs. No joins, filters, or aggregation functions beyond DISTINCT are applied. The ETRM metadata records no additional referenced base objects, confirming the view's dependency is limited to this one table. Users should be aware that the view inherits the data currency of FII_FA_CAT_DIMENSIONS, which is populated as part of the Financial Intelligence dimensional load process; stale or unrefreshed dimension data will surface directly through this view.

Key Columns

The view exposes exactly two columns, both derived by aliasing columns from the base table:

• ID — Aliased from MAJOR_ID. This is the internal identifier of the major asset category segment. Because of the DISTINCT clause, each ID appears once. It functions as the key used in joins to other FII dimension views or to reporting facts.
• VALUE — Aliased from MAJOR_VALUE. This is the descriptive or stored value of the major category segment. It is the column a user typically displays in an LOV or report filter. The search term "major_value" maps directly to this column's underlying source in FII_FA_CAT_DIMENSIONS.

The deliberate naming — generic ID and VALUE — signals that the view is intended as a reusable value-set source, consistent with how Financial Intelligence exposes other category segment views (for example, comparable views for minor or intermediate segments).

Common Use Cases and Queries

Typical uses include populating LOVs, validating category input, and providing a display dimension in Financial Intelligence reports. A straightforward query to list all major categories is:

• SELECT ID, VALUE FROM APPS.FII_ASSET_CAT_MAJOR_V ORDER BY VALUE;

To resolve the value for a known ID:

• SELECT VALUE FROM APPS.FII_ASSET_CAT_MAJOR_V WHERE ID = :major_id;

Because the view has no filter prompts and returns a compact result set, it is well suited to being embedded in a reporting tool's parameter LOV or used as a lookup in a join against asset fact data on the major category key. Note that it provides no date-effective or ledger-specific context; consumers requiring such context must join back to FII_FA_CAT_DIMENSIONS or related FII tables.