Search Results fii_time_qtr




Overview
Explore in AI Chat

Overview

FII_TIME_QTR is a time-dimension table within the Oracle E-Business Suite Financial Intelligence (FII) product family. FII is classified as obsolete in the EBS 12.1.1 and 12.2.2 documentation set, and the object is explicitly marked as not implemented in the reference database. Despite this status, the table definition remains relevant for understanding historical FII schemas, legacy reporting extracts, and upgrade or migration assessments where obsolete FII objects may still exist in customer instances.

The table represents a quarterly calendar dimension, providing a standardized business key for aggregating financial facts by fiscal or calendar quarter. Each row describes a single quarter, its parent year, and the prior-year comparison quarter. Based on the foreign key structure documented in the ETRM metadata, the heuristic Data Vault classification for this object is standalone. From a dimensional modeling perspective, FII_TIME_QTR is best treated as a reference or dimension entity rather than a transactional hub or link; its role is to supply descriptive time attributes that financial fact tables join against.

Key Information Stored

The documented physical schema for FII_TIME_QTR contains 11 columns under owner FII. The most significant are:

  • QUARTER_ID — the surrogate primary key for the quarter, and the column covered by the unique index FII_TIME_QTR_U1, making it the primary business-key candidate.
  • YEAR_ID — foreign key referencing FII_TIME_QTR.YEAR_ID → JAI_FA_AST_YEARS, linking each quarter to its parent fiscal or asset year.
  • NAME — the human-readable quarter label used in reports and dashboards.
  • START_DATE and END_DATE — the inclusive date boundaries of the quarter, enabling range-based filtering and period-to-date calculations.
  • PRIOR_YEAR_QUARTER_ID — self-referencing pointer to the equivalent quarter in the prior year, supporting year-over-year comparison logic without date arithmetic.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns tracking who created and last modified each row, and through which login session.

Common Use Cases and Queries

Because FII_TIME_QTR is a clean time dimension, it is typically joined to period-based financial facts on QUARTER_ID, and to year-level facts through YEAR_ID. A common reporting pattern resolves the quarter name and its date range for a given fiscal year:

  • Joining FII_TIME_QTR to JAI_FA_AST_YEARS on YEAR_ID to report quarter-level balances within a fiscal year.
  • Using START_DATE and END_DATE to constrain fact queries to a specific quarter without hardcoding dates.
  • Resolving PRIOR_YEAR_QUARTER_ID to produce year-over-year variance and trend analyses in a single self-join.
  • Validating loaded quarterly facts by confirming every QUARTER_ID resolves to exactly one row via the FII_TIME_QTR_U1 unique index.

A representative query pattern selects NAME, START_DATE, and END_DATE from FII_TIME_QTR where YEAR_ID is bound to the reporting year, then joins the result to the financial fact table on QUARTER_ID. For year-over-year comparisons, self-join FII_TIME_QTR on QUARTER_ID = PRIOR_YEAR_QUARTER_ID.

Related Objects

The documented foreign key relationship establishes the primary dependency chain for this table:

  • JAI_FA_AST_YEARS — referenced by FII_TIME_QTR.YEAR_ID; the parent year dimension that groups quarters.
  • FII_TIME_QTR itself — self-referenced via PRIOR_YEAR_QUARTER_ID for prior-year quarter lookups.

In practice, FII time dimensions are consumed by FII balances and fact tables that carry QUARTER_ID as a dimension foreign key, and by FII reporting views and extract programs that resolve quarter labels. Because FII is obsolete in 12.1.1 and 12.2.2, customers on those releases should treat any remaining FII_TIME_QTR data as migration input rather than an active integration point, and should confirm object existence before relying on it in new customizations.