Search Results cytd_amt




Overview
Explore in AI Chat

Overview

The view FII_TANDE_EMP_EXP_SUM_V belongs to the Oracle E-Business Suite Financial Intelligence (FII) product family. It is a reporting-layer database object that exposes summarized employee expense data at multiple analytical levels. In the Oracle EBS 12.1.1 and 12.2.2 environments, FII objects such as this view are typically used to feed business intelligence dashboards, Discoverer worksheets, and custom operational reports that aggregate transactional activity across dimensions such as organization, cost center, and accounting period.

The view's primary role is to present a denormalized, query-friendly projection of an underlying summary table, enabling reporting tools and integration interfaces to retrieve quarterly and year-to-date expense figures without directly accessing the base table. The "V" suffix confirms that it is a view rather than a physical table, and the ETRM metadata explicitly notes that the object is not implemented in the reference database — a common characteristic of seeded-but-optional FII objects that are deployed only when the associated Financial Intelligence module is licensed and configured.

Underlying Base Objects

The view is defined as a straightforward projection over a single base object: FII_TANDE_EMP_EXP_SUM. The documented view text is:

No additional joins, filters, or aggregations are applied in the view definition. The ETRM metadata lists no other referenced base objects, confirming a one-to-one column projection. The base table FII_TANDE_EMP_EXP_SUM stores pre-aggregated employee expense summary rows keyed by a hierarchy of level identifiers. Because the view performs no transformation, its row cardinality and grain are identical to the underlying table.

Key Columns

The exposed columns fall into two functional groups: dimensional hierarchy keys and monetary measures.

  • LEVEL9_KEY through LEVEL15_KEY — A contiguous slice of a multi-level dimensional hierarchy (spanning at least fifteen levels). These keys represent progressively finer analytical granularity, such as company, cost center, department, employee, or expense category. Reporting consumers join or decode these keys against FII dimension tables to obtain descriptive labels.
  • CYR_QTD_AMT — Current Year, Quarter-To-Date expense amount.
  • PYR_QTD_AMT — Prior Year, Quarter-To-Date expense amount, used for period-over-period comparison.
  • CYTD_AMT — Current Year-To-Date expense amount.
  • PYTD_AMT — Prior Year-To-Date expense amount, supporting year-over-year variance analysis.

The pairing of current and prior period measures within a single row eliminates the need for self-joins or set operations in downstream reports, simplifying variance and trend calculations.

Common Use Cases and Queries

Typical scenarios include employee expense trend reporting, budget-versus-actual variance analysis, and departmental spend dashboards. A representative query retrieving current and prior year-to-date amounts by hierarchy level follows:

  • SELECT LEVEL9_KEY, LEVEL10_KEY, LEVEL11_KEY, CYTD_AMT, PYTD_AMT, (CYTD_AMT - PYTD_AMT) AS YTD_VARIANCE FROM FII_TANDE_EMP_EXP_SUM_V WHERE CYTD_AMT <> 0 ORDER BY LEVEL9_KEY, LEVEL10_KEY, LEVEL11_KEY;
  • SELECT LEVEL14_KEY, SUM(CYR_QTD_AMT) QTD, SUM(CYTD_AMT) YTD FROM FII_TANDE_EMP_EXP_SUM_V GROUP BY LEVEL14_KEY;

Because the object is documented as not implemented in the reference database, administrators should verify its existence in the target instance via ALL_VIEWS and confirm that the Financial Intelligence module has been fully installed before relying on it in custom reports or integrations.