Search Results fii_fin_item_sets

Overview

FII_FIN_ITEM_SETS is a Financial Intelligence (FII) module table in Oracle E-Business Suite that stores financial item set definitions, one or more per chart of accounts. Financial item sets are logical groupings of General Ledger account balances or financial statement line items used by FII's financial reporting, analysis, and consolidation engines to aggregate, compare, and present balances across a chart of accounts.

The ETRM metadata marks the FII product as Obsolete and states that the table is "Not implemented in this database" in the documented 12.1.1 environment. It should therefore be treated as a legacy or dormant object in 12.1.1 and 12.2.2. Where an FII installation exists, the table underpins financial item set maintenance and reporting configuration. From a dimensional modeling perspective, the mined Data Vault classification of this table is standalone, which suggests modeling it as an independent hub for the financial item set business key, with descriptive attributes carried by a satellite; no parent hub or link dependencies were identified in the FK analysis.

Key Information Stored

The documented physical schema contains eight columns owned by the FII schema. The most significant are:

• FIN_ITEM_SET – The business identifier or name of the financial item set. This is the primary business-key candidate used to reference a specific set within reporting configuration.
• CHART_OF_ACCOUNTS_ID – The chart of accounts to which the item set belongs; the sole documented foreign key, resolving to FII_FIN_ITEM_SETS.CHART_OF_ACCOUNTS_ID → GL_MGT_SEG_UPGRADE_H.
• STATUS_CODE – Lifecycle or enablement status of the item set (for example, active versus inactive), used to filter which sets participate in reporting.
• CREATION_DATE, CREATED_BY – Audit columns capturing when and by whom the row was inserted.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard EBS audit columns recording the most recent modification and the login session responsible for it.

No surrogate primary key column is named in the documented column list; accordingly, uniqueness is conventionally enforced through the combination of FIN_ITEM_SET and CHART_OF_ACCOUNTS_ID. The audit columns are populated by the standard EBS WHO column mechanism and should not be treated as business keys.

Common Use Cases and Queries

Because the table is obsolete and typically not populated, query patterns are most useful for validating migration or upgrade state, auditing residual FII configuration, and reconciling FII definitions against the General Ledger during a 12.1.1-to-12.2.2 upgrade or an FII decommissioning effort.

• Confirm whether any FII configuration remains after upgrade:
  SELECT COUNT(*) FROM fii_fin_item_sets;
• List active item sets by chart of accounts:
  SELECT fin_item_set, chart_of_accounts_id, status_code FROM fii_fin_item_sets WHERE status_code = 'A';
• Audit recent configuration changes using WHO columns:
  SELECT fin_item_set, last_updated_by, last_update_date FROM fii_fin_item_sets ORDER BY last_update_date DESC;
• Join to the documented parent to trace segment-upgrade context:
  SELECT f.fin_item_set, g.* FROM fii_fin_item_sets f JOIN gl_mgt_seg_upgrade_h g ON g.chart_of_accounts_id = f.chart_of_accounts_id;

Report developers should also check for orphaned FII rows referencing chart-of-accounts IDs that no longer exist in the GL ledger definition.

Related Objects

The documented relationship set for this object is intentionally narrow. The principal related objects are:

• GL_MGT_SEG_UPGRADE_H – Referenced by the CHART_OF_ACCOUNTS_ID foreign key; the sole documented parent in the FK graph.
• GL_CODE_COMBINATIONS – The GL chart-of-accounts structure indirectly identified through the same chart-of-accounts identifier, relevant when reconciling FII item sets to account ranges.
• GL_LEDGERS / GL_LEDGER_CONFIGURATIONS – Define the chart of accounts context against which item sets are scoped.
• FII-related reporting and balance tables – Other FII-module objects that consume item set definitions, if present in a legacy installation.

Given the obsolete status, all joins should be validated against current instance metadata before use.