Search Results fii_gl_exp_sum_mv

Overview

FII_GL_EXPENSE_SUMMARY_V1 is a reporting view belonging to the Financial Intelligence (FII) product family within Oracle E-Business Suite. FII is classified as obsolete in the ETRM metadata for releases 12.1.1 and 12.2.2, meaning it is no longer an actively supported or forward-maintained module. The view presents summarized General Ledger expense data organized along time, period type, financial item, manager, and profit center dimensions, and it exposes both a base actual amount column and a derived actual amount column. Its role in the EBS reporting and integration layer was to provide a simplified, pre-joined projection of expense balances so that downstream analytics, dashboards, or extract routines could query a single object rather than reconstruct the aggregation from GL transaction tables. Because the view is layered over a materialized view, it inherits the refresh characteristics of that underlying object rather than reading live transactional data.

Underlying Base Objects

According to the documented view text, FII_GL_EXPENSE_SUMMARY_V1 is defined over exactly one base object: the materialized view FII_GL_EXP_SUM_MV. The ETRM metadata records no additional referenced base tables for this view, so the materialized view is the sole documented dependency. This single-source definition is significant for two reasons. First, it means the aggregation, currency handling, and dimensional grouping all occur within FII_GL_EXP_SUM_MV, and the view merely renames and projects the columns it needs. Second, it means data currency in FII_GL_EXPENSE_SUMMARY_V1 is governed entirely by the refresh schedule configured on FII_GL_EXP_SUM_MV; the view itself adds no filtering, join, or calculation logic that would change the timing or content of the results. The ETRM metadata notes that the object is not implemented in this database, which indicates the underlying materialized view and its supporting FII schema objects may be absent, unlicensed, or removed in a given environment. Any query against this view therefore depends on the presence of FII_GL_EXP_SUM_MV in the same schema.

Key Columns

• TIME_ID — The time dimension identifier associated with the summarized expense record, used to align data to the FII time hierarchy.
• PERIOD_TYPE_ID — Identifies the accounting period type (for example, a month or quarter classification) to which the summarized amount applies.
• FIN_ITEM — The financial item dimension, representing the natural account or line item classification used to categorize the expense. This is the column most frequently referenced by users searching for "fin_item".
• MANAGER_ID — Identifier of the manager or responsibility owner associated with the expense line, supporting responsibility-level reporting.
• PROFIT_CENTER_FLAG — A flag indicating whether the record is attributed to a profit center, enabling segmentation between profit center and non-profit center results.
• ACTUAL_G — The actual expense amount exposed by the view, selected directly from FII_GL_EXP_SUM_MV.

Common Use Cases and Queries

Typical usage centers on dimensional expense analysis by financial item and manager, often filtered by period type and profit center. The view is well suited to aggregate reporting extracts, since all dimensional keys and the measure are already materialized. A representative query groups expense by financial item and period type:

SELECT FIN_ITEM, PERIOD_TYPE_ID, SUM(ACTUAL_G) FROM FII_GL_EXPENSE_SUMMARY_V1 WHERE PROFIT_CENTER_FLAG = 'Y' GROUP BY FIN_ITEM, PERIOD_TYPE_ID;

A second common pattern filters by manager and time to produce responsibility-level expense statements:

SELECT MANAGER_ID, TIME_ID, SUM(ACTUAL_G) FROM FII_GL_EXPENSE_SUMMARY_V1 WHERE TIME_ID = :p_time_id GROUP BY MANAGER_ID, TIME_ID ORDER BY MANAGER_ID;

Because the object is obsolete and documented as not implemented, these queries should be validated against the target environment before use, and any dependent customizations should be reviewed for migration to currently supported GL summary objects.