Search Results month_name

Overview

FII_TANDE_FMNTH_EXP_SUM_V_WH is a reporting view delivered within the Oracle E-Business Suite Financial Intelligence (FII) product family. It is documented as one of the supporting views for the Revenue and Expenses Portal, a component used to present summarized revenue and expense information to business users. The view is a lightweight, warehouse-oriented projection over a single summarized base object rather than a join-intensive composite. Its primary role is to reshape and label pre-aggregated monthly expense data so that downstream portal queries, dashboards, and extract routines can consume it in a consistent, presentation-ready format.

The naming convention carries meaning: the FMNTH segment indicates fiscal-month granularity, EXP indicates expense measures, SUM indicates a pre-summarized source, and the _V_WH suffix denotes a view intended for warehouse/portal consumption. This aligns the view with FII's broader ETRM-based architecture, where thin views isolate report consumers from physical table changes.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined exclusively over a single base object, FII_TANDE_FMNTH_EXP_SUM. No other referenced base objects are documented, and the view contains no joins, unions, or sub-queries. The transformation is purely column-level: the base table's SEQ_ID and measure/key columns pass through unchanged, while MONTH_NAME is truncated to its first three characters via SUBSTR(MONTH_NAME, 1, 3) and re-aliased as MONTH_NAME. This means the view inherits the base table's grain: one summarized row per sequence identifier per fiscal month per key combination.

Note that the ETRM documentation records this object as "Not implemented in this database" for the documented instance, meaning the view (and by extension its base table) may be absent in environments where the Revenue and Expenses Portal is not licensed or configured. Implementers should verify existence before referencing it in custom code.

Key Columns

• SEQ_ID — The sequence identifier that uniquely keys each summarized row. This is the column most commonly used in filtering and joins; since the user searched for "seq_id," it is the primary access path for retrieving a specific month's expense summary.
• MONTH_NAME — The abbreviated (three-character) fiscal month label derived from the base table's full month name.
• CYR_EXP — Current-year expense amount for the summarized period.
• PYR_EXP — Prior-year expense amount, enabling year-over-year comparison directly within one row.
• LEVEL9_KEY through LEVEL15_KEY — A contiguous set of seven hierarchical key columns carrying the dimensional context (for example, organization, cost center, account, or product hierarchy members) at successive levels of the reporting rollup. These keys define the aggregation grain and are typically used in WHERE clauses, GROUP BY operations, or joined to hierarchy/segment tables.

Common Use Cases and Queries

The view supports monthly expense reporting with year-over-year variance, and is well suited to portal extracts and ad hoc analysis. A typical retrieval by sequence identifier is:

SELECT seq_id, month_name, cyr_exp, pyr_exp
FROM   fii_tande_fmnth_exp_sum_v_wh
WHERE  seq_id = :p_seq_id;

A variance query across the dimensional keys is equally straightforward:

SELECT month_name, level9_key, level12_key,
       cyr_exp, pyr_exp, (cyr_exp - pyr_exp) variance
FROM   fii_tande_fmnth_exp_sum_v_wh
ORDER BY month_name, level9_key;

Because the view contains no aggregation logic of its own, consumers should treat it as a filtered projection of the base summary and rely on the LEVEL keys for drill-down. Where finer granularity than the summarized base is required, the underlying transactional or detail objects must be queried instead. As always with FII reporting objects, confirm availability in the target instance before embedding the view in custom reports or interfaces.