Search Results level14_key




Overview
Explore in AI Chat

Overview

FII_TANDE_EMP_EXP_SUM_V_WH is a reporting view shipped as part of the Oracle Financial Intelligence (FII) product family, which is classified in Oracle E-Business Suite 12.1.1 and 12.2.2 as obsolete. The view was originally designed to support the Travel and Expenses Portal, a web-based analytical interface that presented aggregated employee expense information to managers, approvers, and finance personnel. Its name follows the FII naming convention: the "V_WH" suffix denotes a view ("V") intended for a warehouse or summary reporting layer ("WH"), and the core name "TANDE_EMP_EXP_SUM" indicates a travel-and-expense (TANDE) employee expense summary.

Functionally, the view projects a subset of columns from the summary entity FII_TANDE_EMP_EXP_SUM, exposing the Level9 through Level15 key columns together with current- and prior-period amount measures. It performs no filtering or aggregation of its own; it is a thin projection layer whose purpose is to present a stable, portal-facing column list over the underlying summary object. In EBS reporting and integration terms, such a view acts as a presentation contract, isolating downstream portal code from changes to the physical summary table or to lower-level key definitions.

Underlying Base Objects

Per the documented ETRM metadata, the view's referenced base objects are not documented, and the implementation note states that the object is "Not implemented in this database." The view text, however, is explicit and definitive: the sole referenced object is the table or summary object FII_TANDE_EMP_EXP_SUM.

That single-source definition is significant. Because the view selects directly from FII_TANDE_EMP_EXP_SUM without joins, it inherits the grain, partitioning, and any materialized-summary characteristics of that object. No joins to employee, expense, or accounting tables are performed within the view, so all dimensional context must already be encoded in the Level9–Level15 key columns of the base object. The absence of documented base objects in the metadata is consistent with the object's obsolete status: the FII schema objects were withdrawn from later certified EBS configurations, and supporting documentation was accordingly reduced.

Key Columns

The view exposes eleven columns, which fall into two groups: hierarchical summary keys and period amount measures.

  • LEVEL9_KEY through LEVEL15_KEY — Seven key columns representing positions in the FII summary hierarchy. These encode the dimensional context (for example, organization, employee, expense category, or period groupings) at successively deeper levels of granularity. The searched term "level11_key" corresponds to the LEVEL11_KEY column, which is the eleventh level of the summary hierarchy as exposed by this view.
  • CYR_QTD_AMT — Current-year quarter-to-date expense amount.
  • PYR_QTD_AMT — Prior-year quarter-to-date expense amount, used for year-over-year comparison.
  • CYTD_AMT — Current-year-to-date expense amount.
  • PYTD_AMT — Prior-year-to-date expense amount.

The amount columns are aggregate balances rather than transaction amounts, reinforcing the summary nature of the object and its suitability for portal-style comparison reporting.

Common Use Cases and Queries

The primary use case is Travel and Expenses Portal reporting: presenting quarter-to-date and year-to-date expense totals segmented by hierarchy level, with prior-year comparatives. A typical query retrieving all summary rows for a given Level11 grouping would read:

  • SELECT level9_key, level10_key, level11_key, level12_key, level13_key, level14_key, level15_key, cyr_qtd_amt, pyr_qtd_amt, cytd_amt, pytd_amt FROM fii_tande_emp_exp_sum_v_wh;
  • Filtering at a specific level: SELECT * FROM fii_tande_emp_exp_sum_v_wh WHERE level11_key = :p_level11;
  • Year-over-year variance: SELECT level11_key, cytd_amt, pytd_amt, (cytd_amt - pytd_amt) variance FROM fii_tande_emp_exp_sum_v_wh;

Because the object is documented as obsolete and not implemented in the target database, these queries are of historical and migration-analysis value only; on supported 12.1.1 and 12.2.2 environments, equivalent reporting should be sourced from the currently certified expense and FII summary objects.