Search Results major_id

Overview

The Oracle EBS view APPS.FII_ASSET_CAT_MAJOR_V is a lightweight reporting and integration construct exposed in the APPS schema. It presents a distinct list of asset category major dimension values drawn from the FII (Financials Intelligence / Enterprise Performance Foundation) category dimension store. Its intended role is to provide a clean, keyed value list that downstream reports, list-of-values (LOV) queries, and integration interfaces can consume without needing to understand the underlying normalized dimension model.

The view is documented in ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2, and its definition is stable across those releases. It is deliberately minimal: it collapses the dimension table down to two columns, ID and VALUE, which map the surrogate key MAJOR_ID to its business-facing MAJOR_VALUE. This makes it suitable as a lookup source wherever a user must select a major asset category by name while the system stores only the numeric identifier.

Underlying Base Objects

According to the documented view text, the view is defined directly over a single base object:

• FII_FA_CAT_DIMENSIONS — the fixed asset category dimension table that stores the major/minor category hierarchy and their descriptive values.

The view applies a DISTINCT to the projection of MAJOR_ID and MAJOR_VALUE. This is significant: the base dimension table can contain multiple rows sharing the same major identifier (for example, where minor category members are stored on separate rows). The DISTINCT eliminates that duplication so that each major category appears exactly once. The ETRM metadata records no other referenced base objects, and no joins, filters, or sub-queries appear in the documented definition. Consequently, the view carries no additional business logic beyond de-duplication and column aliasing, and its result set is entirely determined by the contents of FII_FA_CAT_DIMENSIONS.

Key Columns

• ID — the aliased form of MAJOR_ID. This is the surrogate numeric key that identifies a major asset category within the FII dimension model. It is the value that would be stored or referenced elsewhere as the category's major identifier.
• VALUE — the aliased form of MAJOR_VALUE. This is the descriptive, user-facing label for the major category, suitable for display in reports, LOVs, and parameter prompts.

Because the view exposes only these two columns, consumers cannot obtain minor category detail, hierarchy attributes, or any descriptive metadata other than the major-level label. Any requirement for deeper category structure must be met by querying FII_FA_CAT_DIMENSIONS directly.

Common Use Cases and Queries

The most frequent application is populating a selection list or joining to a larger report so that major category identifiers resolve to readable names.

• LOV / parameter source — supplying the set of major asset categories from which a user chooses.
• Report enrichment — joining asset facts to this view on ID to display VALUE in output columns.
• Integration extraction — exporting the major category reference set to an external or downstream system.

A representative query retrieving the full reference list, ordered for presentation:

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

A typical join scenario resolving a stored major identifier to its descriptive label:

SELECT f.major_id,
       v.value AS major_category_name
FROM   apps.some_asset_fact_table f,
       apps.fii_asset_cat_major_v v
WHERE  f.major_id = v.id;

As with all APPS-schema views, access is governed by standard EBS security and grants, and query execution benefits from the underlying indexes on FII_FA_CAT_DIMENSIONS. Because the view is a simple projection, its performance characteristics mirror those of the base table.