Search Results fin_item_set_display

Overview

FII_FIN_ITEM_SETS_V is a Financial Intelligence (FII) database view shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose is to serve as an internal view supporting the Financial Item Hierarchy used by the DBI (Daily Business Intelligence) reporting infrastructure. Within this architecture, Financial Item Sets provide the logical grouping mechanism by which General Ledger financial statement line items are aggregated and rolled up for management reporting, and this view exposes the set definitions together with their associated chart of accounts context.

The view is not an end-user reporting object. ETRM documentation explicitly records it as "Not implemented in this database," meaning it may exist only in environments where the relevant DBI/FII patch levels are applied. When present, it acts as a denormalized presentation layer that resolves the raw Financial Item Set records into descriptive, user-readable values. Because the view exposes both CHART_OF_ACCOUNTS_ID and CHART_OF_ACCOUNTS_NAME, it is frequently encountered by users and developers searching for "chart_of_accounts_name," since the Accounting Flexfield structure name is surfaced directly rather than requiring a separate join to FND_ID_FLEX_STRUCTURES. This makes it convenient for troubleshooting hierarchy configuration and for building custom extracts that must identify which chart of accounts a given financial item set belongs to.

The view joins the transaction-level table to multiple FND flexfield and translation tables, applies a language filter based on the session, and restricts results to the "FINANCIAL ITEM SETS" value set and to the GL# Accounting Flexfield (application 101).

Underlying Base Objects

The documented view text reveals the following base objects:

• FII_FIN_ITEM_SETS (aliased GLFIS) — the primary driving table holding Financial Item Set records, including FIN_ITEM_SET, CHART_OF_ACCOUNTS_ID, and audit columns.
• FND_FLEX_VALUE_SETS (FFVS) — filtered on FLEX_VALUE_SET_NAME = 'FINANCIAL ITEM SETS'.
• FND_FLEX_VALUES (FFV) — joined on value set ID and matching FLEX_VALUE to FIN_ITEM_SET.
• FND_FLEX_VALUES_TL (FFVT) — the translated values table, supplying FLEX_VALUE_MEANING and filtered by the session language via USERENV('LANG').
• FND_ID_FLEX_STRUCTURES_V (FIFSV) — the Accounting Flexfield structure view, filtered on APPLICATION_ID = 101 and ID_FLEX_CODE = 'GL#', joined on ID_FLEX_NUM = CHART_OF_ACCOUNTS_ID.

The ETRM metadata records no separately documented referenced base objects beyond those visible in the view text, and the owner is not documented. The joins convert internal IDs into descriptive values and enforce the Financial Intelligence scope.

Key Columns

• ROW_ID — the ROWID of the underlying FII_FIN_ITEM_SETS row, useful for direct row identification.
• FIN_ITEM_SET — the internal identifier of the financial item set.
• FIN_ITEM_SET_DISPLAY — the user-facing, translated name of the item set.
• CHART_OF_ACCOUNTS_ID — the internal Accounting Flexfield structure identifier.
• CHART_OF_ACCOUNTS_NAME — the descriptive chart of accounts name, resolved from the flexfield structures view; the column most relevant to this search.
• STATUS_CODE — the current state of the item set record.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include verifying item set configuration, mapping item sets to chart of accounts, and reconciling Financial Intelligence hierarchy definitions during implementation or upgrade testing. A simple lookup by chart of accounts name is common:

SELECT fin_item_set, fin_item_set_display, chart_of_accounts_name
FROM   fii_fin_item_sets_v
WHERE  chart_of_accounts_name = :chart_of_accounts_name
ORDER BY fin_item_set_display;

Because the object is documented as not implemented in all databases, availability should be confirmed before deployment; if absent, equivalent data can be assembled manually from FII_FIN_ITEM_SETS, FND_FLEX_VALUES, FND_FLEX_VALUES_TL, and FND_ID_FLEX_STRUCTURES_V.