Search Results other_amount_prim




Overview
Explore in AI Chat

Overview

APPS.FII_GL_BASE_MAP_MV_P_V is a reporting and integration view in the Oracle E-Business Suite Financial Intelligence (FII) / Enterprise Performance Foundation product family. It exposes the contents of the materialized view FII_GL_BASE_MAP_MV, which stores General Ledger balance data mapped to the analytical dimensions used by FII fact tables. The view presents a flattened, denormalized projection in which each row represents a mapped GL amount for a specific combination of time, ledger, financial category, and dimension members.

The "_P_V" suffix follows the EBS convention for a "public view" layered over a materialized view, providing a stable API surface for downstream reporting tools, custom concurrent programs, and third-party extract routines. Because the underlying object is a materialized view, queries against this view benefit from precomputed aggregation and join results rather than executing the full GL-to-FII mapping logic at runtime. The view is owned by APPS and is listed as Oracle Proprietary, Confidential Information within the ETRM documentation. The presence of the OTHER_AMOUNT_PRIM column — the term the user searched for — identifies this view as one of the primary sources for the "other amount" primary balance bucket used in FII amount-type reporting.

Underlying Base Objects

The view is defined directly over a single object: FII_GL_BASE_MAP_MV, a materialized view that performs the base GL mapping. As documented in the ETRM metadata for this view, no additional base tables are documented as referenced by the view definition itself. The view acts as a thin projection layer, selecting columns from the materialized view without additional joins or filters.

In practice, FII_GL_BASE_MAP_MV is refreshed from the GL balances and FII mapping tables (dimension mappings, calendar, and ledger definitions). Users should treat FII_GL_BASE_MAP_MV as the authoritative persistence layer and this view as the read interface. Refresh of the materialized view determines data currency, so query results reflect the most recent refresh rather than live GL balances.

Key Columns

Common Use Cases and Queries

This view is most often used to extract balances by amount type for FII fact loading, custom financial reports, or reconciliation between GL and FII reporting. The searched term OTHER_AMOUNT_PRIM is typically used to isolate the "other" amount bucket.

Examples:

  • Retrieve all primary amount buckets for a ledger and period:
    SELECT ledger_id, time_id, prim_actual_g, prim_budget_g, committed_amount_prim, obligated_amount_prim, other_amount_prim FROM apps.fii_gl_base_map_mv_p_v WHERE ledger_id = :ledger_id AND time_id = :time_id;
  • Isolate rows where the "other" primary amount is non-zero:
    SELECT company_dim_id, cost_center_dim_id, other_amount_prim FROM apps.fii_gl_base_map_mv_p_v WHERE other_amount_prim <> 0;
  • Aggregate committed versus obligated amounts by company:
    SELECT company_dim_id, SUM(committed_amount_prim), SUM(obligated_amount_prim) FROM apps.fii_gl_base_map_mv_p_v GROUP BY company_dim_id;
  • Reconcile GL postings by date:
    SELECT posted_date, SUM(baseline_amount_prim) FROM apps.fii_gl_base_map_mv_p_v WHERE posted_date BETWEEN :from_date AND :to_date GROUP BY posted_date;

Because the view exposes dimension IDs rather than descriptive names, join to the corresponding FII dimension views or GL flex value tables to produce user-facing labels. Always qualify the view with the APPS schema and account for materialized view refresh timing when comparing to GL.