Search Results fin_category_dim_id

Overview

APPS.FII_GL_TREND_SUM_MV_P_V is a reporting view in the Oracle E-Business Suite Financial Intelligence (FII) product family. It presents a flattened, business-friendly projection of the materialized view FII_GL_TREND_SUM_MV, exposing summarized General Ledger trend data organized by time, period type, budget version, and a layered set of financial dimensions (company, cost center, and financial category). The "_P_V" suffix conventionally denotes a "public" presentation view, indicating that the object is intended for direct consumption by reports, dashboards, and analytical queries rather than for internal ETL processing.

The view plays a supporting role in GL trend analysis and budgetary reporting. By surfacing both primary (functional currency) and secondary ("prim") amount columns alongside a baseline figure, it enables period-over-period comparisons of actuals, budgets, forecasts, commitments, obligations, and other encumbrances. The user search term "committed_amount_prim" corresponds directly to one of the view's exposed columns, COMMITTED_AMOUNT_PRIM, which reports committed amounts in the primary ledger currency.

Underlying Base Objects

The view is defined over a single base object: the materialized view FII_GL_TREND_SUM_MV. The ETRM metadata for this view lists no additional referenced objects beyond that materialized view, meaning all dimensional and measure columns are inherited directly from FII_GL_TREND_SUM_MV without joins, unions, or derived expressions in the view definition itself. The view essentially acts as a column-selective pass-through over the materialized view, which itself aggregates GL balances and encumbrance data at a summarized grain.

Because the underlying object is a materialized view, the data available through this view reflects the refresh schedule configured for FII_GL_TREND_SUM_MV. Reporting consumers should be aware that the "SUM" grain means individual journal lines and encumbrance detail are already collapsed; the view is designed for aggregate trend reporting rather than transactional drill-down.

Key Columns

• TIME_ID, PERIOD_TYPE_ID — Identify the accounting period and the period-type classification (for example, month, quarter, or year) used for trend bucketing.
• BUDGET_VERSION_DATE — The effective date of the budget version associated with the summarized amounts, allowing comparison across budget revisions.
• PARENT_COMPANY_DIM_ID, COMPANY_DIM_ID — Hierarchical company dimension identifiers supporting roll-up analysis.
• PARENT_COST_CENTER_DIM_ID, COST_CENTER_DIM_ID — Cost center hierarchy identifiers for organizational reporting.
• PARENT_FIN_CATEGORY_DIM_ID, FIN_CATEGORY_DIM_ID, TOP_NODE_FIN_CAT_TYPE — Financial category dimension identifiers and the top-node category type, used to classify balances by natural account grouping.
• ACTUAL_B — Base actual amount, typically the stored base-currency actual figure.
• PRIM_ACTUAL_G, PRIM_BUDGET_G, PRIM_FORECAST_G — Actual, budget, and forecast amounts expressed in the primary ledger currency.
• COMMITTED_AMOUNT_PRIM — Committed (purchase order commitment) amounts in primary currency; this is the column referenced by the user's search.
• OBLIGATED_AMOUNT_PRIM — Obligated amounts (requisition or other pre-commitment encumbrances) in primary currency.
• OTHER_AMOUNT_PRIM — Residual or miscellaneous encumbrance amounts in primary currency.
• BASELINE_AMOUNT_PRIM — The baseline (original budget or reference) amount in primary currency, used as the comparative anchor for variance analysis.

Common Use Cases and Queries

Typical scenarios include trend reporting on commitments versus budget, budget-versus-actual variance analysis by cost center, and multi-period encumbrance dashboards. A representative query filtering on the user's search term might read:

• Aggregating committed spend by period: SELECT time_id, SUM(committed_amount_prim) FROM apps.fii_gl_trend_sum_mv_p_v GROUP BY time_id ORDER BY time_id;
• Variance reporting: SELECT company_dim_id, cost_center_dim_id, SUM(prim_budget_g) budget, SUM(prim_actual_g) actual, SUM(committed_amount_prim) committed FROM apps.fii_gl_trend_sum_mv_p_v GROUP BY company_dim_id, cost_center_dim_id;
• Encumbrance composition across commitment, obligation, and other categories for a given financial category and period.

Because the view is a thin projection of a materialized view, query performance is generally strong for aggregate reporting, and the view is well suited to being consumed by BI Publisher reports, OBIEE repositories, and custom FII dashboards.