Search Results actual_b




Overview
Explore in AI Chat

Overview

APPS.FII_GL_MGMT_SUM_V2 is a reporting and integration view in the Oracle E-Business Suite Financials Intelligence (FII) product family. It is designed to expose summarized general ledger actual, budget, and forecast balances organized by management hierarchy dimension — manager, person, line of business, and financial category. The view is a thin projection over a materialized view, which means it delivers pre-aggregated data rather than executing the aggregation at query time. This design supports high-performance dashboards, Hyperion/Essbase-style planning integrations, and management reporting extracts that need consistent period-by-period financial summaries across an entire enterprise.

Because the object is a view rather than a base table, it does not itself store data; it presents a governed, read-only interface to the underlying materialized view. That makes it suitable for customer-authored reports, custom concurrent programs, and outbound extracts where direct access to the materialized view would be inadvisable.

Underlying Base Objects

Per the ETRM documentation, the view is defined with a single source: FII_GL_MGMT_SUM_MV. The view text selects columns directly from this materialized view with no joins, filters, or transformations:

SELECT time_id, period_type_id, manager_id, person_id, actual_b, sec_actual_g, line_of_business_id, parent_fin_category_id, fin_category_id, gid, sec_budget_g, sec_forecast_g FROM fii_gl_mgmt_sum_mv

No base tables are documented as being referenced by the view itself; all lineage traces to the materialized view, which in turn is refreshed from GL balances and FII dimension/staging objects. Consequently, data currency in FII_GL_MGMT_SUM_V2 depends entirely on the refresh schedule of the underlying materialized view.

Key Columns

  • time_id — Identifier for the accounting period or calendar time dimension the row aggregates to.
  • period_type_id — Distinguishes period types (e.g., month, quarter, year) applied to the time_id.
  • manager_id — The management hierarchy node (manager) to which the summarized amounts are attributed.
  • person_id — The individual (employee or resource) associated with the summarized amounts.
  • actual_b — The actual balance amount at the base currency/grain level. This is the column most frequently referenced when users search for "actual_b".
  • sec_actual_g — Secondary actual amount, typically a group or reporting-currency equivalent of actuals.
  • sec_budget_g — Secondary budget amount at group/reporting currency.
  • sec_forecast_g — Secondary forecast amount at group/reporting currency.
  • line_of_business_id — Line-of-business dimension used to segment results.
  • parent_fin_category_id and fin_category_id — Parent and child financial category identifiers, providing a hierarchy for P&L or balance sheet classification.
  • gid — Global identifier linking the summarized row to the batch or grouping that produced it.

Common Use Cases and Queries

Typical use cases include management P&L reporting by manager and line of business, actual-versus-budget-versus-forecast comparisons, and extracts feeding external planning tools. Because the view is pre-aggregated, queries are simple and fast.

  • Actuals by manager and period:

    SELECT manager_id, time_id, SUM(actual_b) actual_total FROM apps.fii_gl_mgmt_sum_v2 WHERE period_type_id = :p_type GROUP BY manager_id, time_id;

  • Actual versus budget versus forecast by financial category:

    SELECT fin_category_id, SUM(actual_b) act, SUM(sec_budget_g) bud, SUM(sec_forecast_g) fcst FROM apps.fii_gl_mgmt_sum_v2 GROUP BY fin_category_id;

  • Joint actuals and group actuals by line of business:

    SELECT line_of_business_id, SUM(actual_b) base_actual, SUM(sec_actual_g) grp_actual FROM apps.fii_gl_mgmt_sum_v2 GROUP BY line_of_business_id;

All queries should be issued against APPS.FII_GL_MGMT_SUM_V2 rather than the materialized view directly, and users should verify the refresh status of FII_GL_MGMT_SUM_MV before relying on results for period close or regulatory reporting.