Search Results fii_gl_local_snap_f_p_v

Overview

The view FII_GL_LOCAL_SNAP_F_P_V belongs to the Financial Intelligence (FII) product family within Oracle E-Business Suite, specifically the Financial Intelligence applications that provide dimensional analysis and reporting over General Ledger balances. In the Oracle EBS 12.1.1 and 12.2.2 releases, this object is defined in the APPS schema with a status of VALID and serves as a presentation-layer projection over the local snapshot fact table that stores period-based GL balances across multiple time horizons.

The view exposes monthly, quarterly, and year-to-date aggregations in a single flattened row per dimensional combination, allowing reporting tools, BI Publisher extracts, and downstream integration processes to retrieve pre-aggregated General Ledger figures without issuing dynamic grouping logic. Because the view selects from a snapshot fact table rather than directly from GL_ balances, it reflects data as captured during the FII snapshot/ETL cycle, which is a key consideration for anyone searching on the g_year column.

Underlying Base Objects

According to the documented ETRM metadata, the view text is a straightforward projection over a single base object, FII_GL_LOCAL_SNAP_F:

• FII_GL_LOCAL_SNAP_F — the local snapshot fact table holding General Ledger balances at the lowest grain of the FII star schema (year, ledger, company, cost center, financial category, and user-defined dimensions).
• No other referenced base objects are documented for this view; the ETRM metadata lists no additional dependencies beyond this fact table.
• Column aliasing is applied in the view text, mapping USER_DIM1_ID to FUD1_ID, USER_DIM2_ID to FUD2_ID, and the PRIM_G_* columns to their shorter G_* aliases.

Because it is a thin wrapper, the view adds no joins, filters, or aggregations of its own; all dimensional context and balance values are inherited directly from the fact table.

Key Columns

• Dimension keys: YEAR_ID, COST_CENTER_ID, COMPANY_ID, FIN_CATEGORY_ID, FUD1_ID, FUD2_ID, and LEDGER_ID define the grain of each row.
• Classification: FIN_CAT_TYPE_CODE and AMOUNT_TYPE_CODE distinguish the nature of the financial category and the amount type (for example, period activity versus balance).
• Monthly balances: G_MONTH1 through G_MONTH13, corresponding to the aliased PRIM_G_MONTH1..13 source columns and supporting a thirteen-period accounting calendar.
• Quarterly balances: G_QTR1, G_QTR2, G_QTR3, G_QTR4.
• Aggregate horizon columns: G_YEAR (full-year total), G_MTD (month-to-date), G_QTD (quarter-to-date), and G_YTD (year-to-date). G_YEAR is the column most frequently referenced when users search for g_year.
• Audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical uses include extracting annual or year-to-date GL balances for a ledger and year, feeding period-end reporting packs, and supporting dimensional reconciliation between FII and the base General Ledger.

Example — retrieve annual balances for a given year and ledger:

• SELECT year_id, ledger_id, company_id, cost_center_id, fin_category_id, g_year
• FROM apps.fii_gl_local_snap_f_p_v
• WHERE year_id = :p_year_id
•   AND ledger_id = :p_ledger_id
•   AND amount_type_code = :p_amount_type;

Example — compare year-to-date and quarterly totals:

• SELECT year_id, ledger_id, company_id, g_ytd, g_qtr1, g_qtr2, g_qtr3, g_qtr4
• FROM apps.fii_gl_local_snap_f_p_v
• WHERE year_id = :p_year_id
•   AND fin_cat_type_code = :p_cat_type;

Because the view inherits from a snapshot fact table, query results reflect the most recent snapshot load rather than live GL balances, which should be accounted for in any reconciliation or reporting logic.