Search Results committed_amount_prim

Overview

FII_GL_AGRT_SUM_MV_P_V is an APPS-owned database view in the FII (Financial Intelligence) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. The suffix convention indicates that it is a presentation-layer view (_P_V) projecting from a materialized view (_MV), in this case FII_GL_AGRT_SUM_MV. Its purpose is to expose aggregated General Ledger balances across multiple accounting dimensions and amount types, including committed, obligated, and other budgetary measures, in a form suited to FII reporting and analytics tools.

The view presents period-based summary balances keyed by time, ledger, financial category, and company/cost center/user-defined dimensions. Because it is a simple column projection over the materialized view, it introduces no additional join or filter logic; the aggregation and pre-computation are entirely inherited from the underlying materialized view.

Underlying Base Objects

The documented view text defines FII_GL_AGRT_SUM_MV_P_V solely over FII_GL_AGRT_SUM_MV, selecting a defined column list directly from that materialized view. No further base tables are documented at the view level, though the materialized view itself is understood to be refreshed from GL aggregate and summary sources and dimension hierarchies within the FII schema.

• Direct source: FII_GL_AGRT_SUM_MV (materialized view).
• Schema: APPS (public synonym access).
• No additional joins, WHERE clauses, or transformations are applied in the view definition.

Because FII_GL_AGRT_SUM_MV is materialized, data freshness depends on the refresh schedule configured for that MV, not on the view itself.

Key Columns

The view exposes the following functional groups of columns:

• Time and period: TIME_ID, PERIOD_TYPE_ID, and POSTED_DATE for temporal analysis.
• Ledger: LEDGER_ID identifies the accounting ledger.
• Financial categories: PARENT_FIN_CATEGORY_ID and FIN_CATEGORY_ID for category rollups.
• Company dimension: PARENT_COMPANY_DIM_ID and COMPANY_DIM_ID.
• Cost center dimension: PARENT_COST_CENTER_DIM_ID and COST_CENTER_DIM_ID.
• User-defined dimensions: PARENT_USER_DIM1_ID, USER_DIM1_ID, USER_DIM2_ID.
• Amount measures (primary): PRIM_ACTUAL_G, PRIM_BUDGET_G, PRIM_FORECAST_G.
• Committed and related measures: COMMITTED_AMOUNT_PRIM, OBLIGATED_AMOUNT_PRIM, OTHER_AMOUNT_PRIM, BASELINE_AMOUNT_PRIM, plus ACTUAL_B.

The searched term committed_amount_prim maps to COMMITTED_AMOUNT_PRIM, a primary (functional-currency) committed amount measure. The _PRIM suffix denotes the primary ledger currency representation, distinguishing it from global or secondary currency equivalents.

Common Use Cases and Queries

This view is typically used for budget-versus-actual, commitment, and obligation analysis by dimension. A representative query isolating committed amounts is:

• SELECT LEDGER_ID, TIME_ID, FIN_CATEGORY_ID, COMPANY_DIM_ID, COMMITTED_AMOUNT_PRIM FROM APPS.FII_GL_AGRT_SUM_MV_P_V WHERE COMMITTED_AMOUNT_PRIM IS NOT NULL;

Filtering by COMMITTED_AMOUNT_PRIM is effective for identifying periods or categories carrying commitment activity. Aggregations across dimensions are straightforward given the denormalized structure of the parent materialized view.

Because the view performs no filtering, applications should apply ledger, period, and category predicates explicitly to limit result sets. Consult the materialized view refresh settings to determine data recency before relying on results for period-close reporting.