Results for “summary_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FII_FC_TYPE_NORM_ASSIGN is a Financial Intelligence (FII) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the assignment of a Financial Category type to each Financial Category dimension value. In other words, it classifies every member of the Financial Category dimension into one of the standard Financial Category types — Revenue, Operating Expense, Travel and Entertainment, Cost of Goods Sold, and Product Expenses — providing the semantic mapping that drives Financial Intelligence reporting, normalization, and analytical processing. Without this mapping, Financial Category dimension values would carry no meaningful financial behavior for downstream FII calculations.

The object is owned by the FII schema and is marked VALID and standalone. The heuristic Data Vault classification mined from the foreign key structure is standalone, meaning no FK relationships to other tables were detected. As a modeling suggestion, this could be considered a hub-like entity over the Financial Category identifier, or, given its role of holding descriptive classification attributes (the category type, summary flag, and audit columns), it may also be modeled as a satellite attached to a Financial Category hub. The absence of FK constraints means the classification is suggestive only.

Key Information Stored

The documented physical schema in ETRM 12.1.1 comprises nine columns. The most significant are listed below.

• FIN_CATEGORY_ID — Surrogate identifier for the Financial Category dimension value. Part of the composite primary key and the principal join column to the Financial Category dimension.
• FIN_CAT_TYPE_CODE — The assigned Financial Category type code (Revenue, Operating Expense, Travel and Entertainment, Cost of Goods Sold, or Product Expenses). Part of the composite primary key and the core business attribute of this table.
• FIN_CATEGORY — The descriptive name of the Financial Category value, carried on the assignment row for reporting convenience.
• SUMMARY_FLAG — Indicates whether the Financial Category value is a summary (parent) member, used to control aggregation behavior in FII reporting.
• CREATION_DATE, CREATED_BY — Standard audit columns recording when and by whom the assignment row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent modification to the row.

The primary key, FII_FC_TYPE_NORM_ASSIGN_PK, is composite over (FIN_CATEGORY_ID, FIN_CAT_TYPE_CODE). This constrains each Financial Category value to a single Financial Category type assignment, since the pair must be unique. The business-key candidate is therefore the combination of FIN_CATEGORY_ID and FIN_CAT_TYPE_CODE rather than either column alone.

Common Use Cases and Queries

Principal scenarios include validating that every Financial Category dimension value has a type assignment, reporting Financial Category values grouped by type, and driving FII normalization logic that maps source balances to reporting lines. A typical audit query identifies unassigned or misassigned members:

• Unassigned categories: select from the Financial Category dimension where FIN_CATEGORY_ID is not present in FII_FC_TYPE_NORM_ASSIGN.
• Type distribution: select FIN_CAT_TYPE_CODE, count(*) from FII_FC_TYPE_NORM_ASSIGN group by FIN_CAT_TYPE_CODE.
• Joined reporting: join FII_FC_TYPE_NORM_ASSIGN to the Financial Category dimension on FIN_CATEGORY_ID, filtering by FIN_CAT_TYPE_CODE and SUMMARY_FLAG.
• Change tracking: filter on LAST_UPDATE_DATE to identify recently modified assignments during period-close reconciliation.

Related Objects

The metadata documents this object as standalone, with no mined foreign key relationships. The most significant related objects, based on the documented join column and FII domain context, are:

• Financial Category dimension table in the FII schema — joined on FIN_CATEGORY_ID; supplies the dimension members being classified.
• FII Financial Category hierarchy objects — consume SUMMARY_FLAG to determine parent/child aggregation.
• FII fact and balance tables — reference Financial Category values whose types are resolved through this table.
• FII normalization and reporting views — read FIN_CAT_TYPE_CODE to map balances into Revenue, Operating Expense, and other reporting lines.
• Concurrent programs and FII setup forms — create and maintain the assignments recorded here.