Search Results fii_gl_local_snap_f




Overview
Explore in AI Chat

Overview

FII_GL_LOCAL_SNAP_F is a summary/snapshot table within the Financial Intelligence (FII) product family, a component of Oracle E-Business Suite historically associated with financial consolidation, analytical reporting, and dimensional summarization of General Ledger data. Per the ETRM metadata, the table stores data found in FII_GL_JE_SUMMARY_B restructured by column, effectively pivoting journal-entry summary figures into period-specific amount columns. The product designation is FII — Financial Intelligence (Obsolete), meaning the object belongs to a discontinued or superseded feature set and may not be populated or implemented in all EBS 12.1.1 or 12.2.2 instances. The metadata explicitly records "Not implemented in this database," indicating that the table definition may exist in the schema or data dictionary without corresponding runtime data.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. This suggests the table functions independently within a reporting or snapshot model rather than acting as a canonical hub, link, or satellite in a Data Vault topology. Under 12.1.1 documented physical schema, the table is owned by the FII schema and contains 56 columns. Despite the "obsolete" status, the table remains relevant for historical reporting, data migration assessment, and understanding legacy consolidation logic.

Key Information Stored

The table is structured around a dimensional key set plus a large block of period measures. The most significant columns include:

The metadata does not document a distinct surrogate primary key column; the composite of YEAR_ID, COMPANY_ID, COST_CENTER_ID, FIN_CATEGORY_ID, LEDGER_ID and related dimensions behaves as the effective business key. No unique index is explicitly enumerated in the supplied metadata.

Common Use Cases and Queries

Because the table stores pre-aggregated balances by period, it is well suited to financial reporting that avoids re-summarizing FII_GL_JE_SUMMARY_B on each run. Typical patterns include retrieving year-to-date balances by company and ledger:

  • SELECT COMPANY_ID, LEDGER_ID, SUM(PRIM_G_YTD) FROM FII_GL_LOCAL_SNAP_F GROUP BY COMPANY_ID, LEDGER_ID.
  • Monthly trend extraction using PRIM_G_MONTH1..PRIM_G_MONTH12 in a UNION or UNPIVOT.
  • Primary-versus-secondary currency reconciliation comparing PRIM_G_* and SEC_G_* measures for the same dimensional key set.
  • Period-over-period variance analysis using PRIM_G_QTD and PRIM_G_QTR columns.

Given the obsolete classification, queries should confirm row presence before relying on output, particularly in 12.2.2 environments where the FII feature may be dormant.

Related Objects

The following objects are most significant in relation to this table:

  • JAI_FA_AST_YEARS — joined via YEAR_ID to resolve fiscal year attributes.
  • PN_COMPANIES_ALL — joined via COMPANY_ID to obtain legal-entity and company descriptions.
  • FII_GL_JE_SUMMARY_B — the source summary table whose data is restructured into this snapshot by column, per the documented description.
  • GL_LEDGERS — referenced through LEDGER_ID for ledger name and currency context.
  • FII_GL_JE_SUMMARY_T / related FII summary objects — companion summary structures within the Financial Intelligence schema.
  • Standard FND who-column lookups (FND_USER) — resolved through CREATED_BY and LAST_UPDATED_BY for audit reporting.