Search Results fii_fin_cat_type_code

Overview

The view APPS.FII_FC_TYPE_ASSGNS_V is a financial intelligence reporting object that consolidates financial category type assignments used within the Oracle E-Business Suite Financial Intelligence (FII) and Enterprise Trade Management (ETRM) data model. It presents a unified list of financial category type codes and their associated financial category identifiers, allowing downstream reporting, integration, and hierarchy resolution routines to reference a single, aggregated source rather than querying multiple disparate tables.

The object is particularly relevant when the column FIN_CAT_TYPE_CODE is referenced. This code identifies the category type under which financial items are grouped (for example, revenue, cost, or asset categories applied against the GL_FII_FIN_ITEM financial dimension). The view plays a supporting role in FII-based dimensional reporting, where financial items must be mapped to their correct category hierarchies for extraction, transformation, and loading into analytical warehouses or third-party systems.

Underlying Base Objects

The view is defined as a UNION ALL of two distinct query blocks, each drawing from separate underlying base objects. Documented base objects are listed as none within the ETRM metadata, but the view text itself exposes the source tables and seed entities used in its construction.

• FII_FIN_CAT_TYPE_ASSGNS — Supplies the first result set, contributing the columns FIN_CAT_TYPE_CODE, FIN_CATEGORY_ID, and TOP_NODE_FLAG.
• FII_FINANCIAL_DIMENSIONS — Joined in the second query block (aliased D) to retrieve the top-node identifier via DBI_HIER_TOP_NODE_ID, filtered on DIMENSION_SHORT_NAME = 'GL_FII_FIN_ITEM'.
• FND_LOOKUP_VALUES_VL — Joined in the second query block (aliased V) to obtain the lookup code, filtered by LOOKUP_TYPE LIKE 'FII_FIN_CAT_TYPE_CODE'.

The UNION ALL structure means assignments explicitly stored in the assignment table are combined with category types derived dynamically from lookup values and the financial dimension configuration, without de-duplication. The second branch sets TOP_NODE_FLAG to NULL, reflecting that top-node designation is only meaningful for explicitly stored assignments.

Key Columns

• FIN_CAT_TYPE_CODE — The financial category type code. In the first branch it is sourced directly from the assignment table; in the second it is derived from FND_LOOKUP_VALUES_VL.LOOKUP_CODE.
• FIN_CATEGORY_ID — The financial category identifier. In the first branch this is the stored category ID; in the second it corresponds to FII_FINANCIAL_DIMENSIONS.DBI_HIER_TOP_NODE_ID, effectively resolving the top hierarchy node for the GL_FII_FIN_ITEM dimension.
• TOP_NODE_FLAG — A flag indicating whether the assignment corresponds to a top node. Populated from FII_FIN_CAT_TYPE_ASSGNS in the first branch and returned as NULL for lookup-derived rows.

Common Use Cases and Queries

Typical scenarios include validating that every financial category type code defined in lookups has a corresponding category assignment, and resolving category types to their top hierarchy nodes for report grouping.

Retrieve all assignments for a specific category type:

• SELECT fin_cat_type_code, fin_category_id, top_node_flag FROM apps.fii_fc_type_assgns_v WHERE fin_cat_type_code = :p_code;

Identify lookup-derived rows lacking a top-node flag:

• SELECT fin_cat_type_code, fin_category_id FROM apps.fii_fc_type_assgns_v WHERE top_node_flag IS NULL;

Because the view is a UNION ALL, consumers should anticipate duplicate FIN_CAT_TYPE_CODE values across the two branches and apply appropriate filtering or aggregation when de-duplication is required.