Search Results forecast_g




Overview
Explore in AI Chat

Overview

The view FII_GL_SUMMARY_BY_PROD_V1 belongs to the Oracle Financial Intelligence (FII) product family, a component of the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases. FII was designed to deliver analytical and management reporting over General Ledger balances, aggregating financial data across time, managerial responsibility, and product dimensions. The _V1 suffix denotes a versioned reporting interface, indicating that Oracle published this view as a stable, named contract for downstream reports, dashboards, and integration extracts rather than as an internal implementation detail.

The view presents a consolidated financial summary organized by product category, time period, and financial item. It exposes aggregated Actual, Budget, and Forecast measures side by side, which is its defining characteristic. Because it unifies three distinct planning and reporting perspectives in a single row, it supports variance analysis, trend reporting, and forward-looking comparison in one query.

It should be noted that the metadata classifies FII as Obsolete and records that the view is "Not implemented in this database." The documented ETRM 12.2.2 entry lists no owner and no referenced base objects, reflecting that the object may be absent from the current installation and retained only for historical compatibility. Consumers should confirm existence before relying upon it in production code.

Underlying Base Objects

According to the documented view text, FII_GL_SUMMARY_BY_PROD_V1 is defined exclusively over the materialized view FII_GL_PRD_SUM_MV. The view is a thin projection: it selects columns from that materialized view and applies column aliasing to rename the aggregated measures to simpler external names (ACTUAL_G, BUDGET_G, FORECAST_G). No joins, filters, or aggregation logic are applied within the view itself; all summarization occurs in the underlying materialized view.

This design is typical of FII reporting layers, where a materialized view performs the heavy aggregation work and versioned views provide a controlled, alias-stabilized interface. Because the view is a simple wrapper, its performance and freshness characteristics are entirely inherited from FII_GL_PRD_SUM_MV, including its refresh schedule. If the materialized view is stale or has been dropped, the view will either return outdated data or fail entirely. The ETRM documentation records no other referenced base objects, so the dependency chain terminates at this single materialized view.

Key Columns

  • TIME_ID — Identifier for the accounting period or time bucket to which the summary row applies.
  • PERIOD_TYPE_ID — Distinguishes the period type (for example, month, quarter, or year) associated with the time identifier.
  • FIN_ITEM — The financial line item or account classification being summarized.
  • MANAGER_ID — Identifier of the manager responsible for the reported balances, supporting management-level reporting.
  • PRODUCT_CATEGORY_ID — The product category dimension, which is the principal organizing attribute of this summary.
  • PROFIT_CENTER_FLAG — Indicator of whether the row is scoped to a profit center.
  • ACTUAL_G — Aggregated actual balances; aliased from PRIM_ACTUAL_G in the base materialized view.
  • BUDGET_G — Aggregated budgeted balances; aliased from PRIM_BUDGET_G.
  • FORECAST_G — Aggregated forecast balances; aliased from PRIM_FORECAST_G. This column is directly relevant to the user search term "forecast_g" and represents the projected financial position.

Common Use Cases and Queries

Typical uses include product category profitability reporting, actual-versus-budget versus forecast variance analysis, and extraction of forecast measures to external planning systems. A representative query returns forecast balances for a given period and product category:

  • SELECT PRODUCT_CATEGORY_ID, FIN_ITEM, TIME_ID, ACTUAL_G, BUDGET_G, FORECAST_G FROM FII_GL_SUMMARY_BY_PROD_V1 WHERE PERIOD_TYPE_ID = :period_type AND PRODUCT_CATEGORY_ID = :category_id ORDER BY TIME_ID;
  • Variance reporting: SELECT PRODUCT_CATEGORY_ID, FIN_ITEM, (ACTUAL_G - BUDGET_G) budget_variance, (ACTUAL_G - FORECAST_G) forecast_variance FROM FII_GL_SUMMARY_BY_PROD_V1 WHERE TIME_ID = :time_id;
  • Forecast extraction: SELECT MANAGER_ID, PRODUCT_CATEGORY_ID, SUM(FORECAST_G) FROM FII_GL_SUMMARY_BY_PROD_V1 WHERE PROFIT_CENTER_FLAG = 'Y' GROUP BY MANAGER_ID, PRODUCT_CATEGORY_ID;

Because the view is documented as obsolete and not implemented, any such query should first verify the view's presence and the availability of FII_GL_PRD_SUM_MV in the target environment.