Search Results fii_fa_cat_dimensions_n2

Overview

FII.FII_FA_CAT_DIMENSIONS is an Oracle E-Business Suite table in the FII (Financial Intelligence for Assets / Enterprise Performance Foundation) schema that stores Asset Category dimension information. It is part of the Oracle Enterprise Performance Foundation / Enterprise Resource Planning (ETRM) data model used by Oracle EBS 12.1.1 and 12.2.2. The table holds one record for each asset category flexfield defined in the system, along with surrogate identifiers and descriptive values that are consumed by the base summary extract processes.

The table is owned by the FII schema, resides in the APPS_TS_TX_DATA tablespace, and is classified as VALID with FND design data registered as FII.FII_FA_CAT_DIMENSIONS. Within a heuristic Data Vault classification, this object is modeled as a standalone structure — effectively a dimension reference table served by a surrogate key rather than a hub, link, or satellite construct. It is referenced by the APPS synonym FII_FA_CAT_DIMENSIONS and does not itself reference any upstream database object through a foreign key relationship.

Key Information Stored

The table contains eleven documented columns. The most significant are summarized below, distinguishing the surrogate primary key from the documented business-key candidate.

• CATEGORY_ID (NUMBER(15)) — The key flexfield combination defining column that serves as the surrogate primary key of the table through the unique index FII_FA_CAT_DIMENSIONS_U1.
• FLEX_STRUCTURE_ID (NUMBER(15)) — The key flexfield structure defining column that ties the category to its flexfield structure in FII_FA_CAT_SEGMENTS.
• MAJOR_ID / MAJOR_VALUE — The major category identifier and its 240-character descriptive value.
• MINOR_ID / MINOR_VALUE — The minor category identifier and its 240-character descriptive value.
• Standard WHO columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN, which support audit and concurrency requirements.

The unique index FII_FA_CAT_DIMENSIONS_U1 on CATEGORY_ID is the documented business-key candidate. Two nonunique indexes, FII_FA_CAT_DIMENSIONS_N1 (on MAJOR_VALUE, MINOR_VALUE) and FII_FA_CAT_DIMENSIONS_N2 (on MAJOR_ID, MINOR_ID), support lookup and reporting access paths.

Common Use Cases and Queries

The table is most commonly queried to resolve asset category identifiers into human-readable major and minor category values, or to join category flexfield combinations to downstream summary extracts. A canonical retrieval joining the ID-based and value-based access paths is shown below.

• Resolving category values for reporting: SELECT CATEGORY_ID, MAJOR_VALUE, MINOR_VALUE FROM FII.FII_FA_CAT_DIMENSIONS;
• Joining to the flexfield structure definition: SELECT c.CATEGORY_ID, c.MAJOR_VALUE, c.MINOR_VALUE, s.FLEX_STRUCTURE_ID FROM FII.FII_FA_CAT_DIMENSIONS c, FII.FII_FA_CAT_SEGMENTS s WHERE c.FLEX_STRUCTURE_ID = s.FLEX_STRUCTURE_ID;
• Driving base summary extracts where category dimension attributes must be expanded into hierarchical major/minor groupings.

Related Objects

The most significant documented relationship is the foreign key from this table's FLEX_STRUCTURE_ID to FII.FII_FA_CAT_SEGMENTS, which defines the key flexfield structures that categorize asset segments. Beyond this FK, the object is exposed to the application layer through the APPS synonym FII_FA_CAT_DIMENSIONS, which is the standard access point for concurrent programs, PL/SQL packages, and BI Publisher reports. Business intelligence extracts and Enterprise Performance Foundation summary processes that depend on asset category dimensions use this synonym and the child relationship to FII_FA_CAT_SEGMENTS to build category hierarchies. No additional foreign key dependencies are documented, confirming its standalone Data Vault classification.