Search Results fii_time_qtr_u1

Overview

FII.FII_TIME_QTR is a time-dimension reference table residing in the FII schema, stored in the APPS_TS_SUMMARY tablespace. It represents a calendar quarter within the Oracle EBS financial intelligence and Enterprise Tax Reporting Management (ETRM) data model. Each row describes one quarter of a Gregorian year, supplying the descriptive attributes (name, start date, end date) and hierarchical pointers required to aggregate transactional facts by quarter for reporting, tax year roll-up, and period-over-period comparison.

Given its role as a standalone dimension table with a stable surrogate key, the metadata heuristic suggests modeling this object as a satellite or dimension hub in Data Vault terms — it does not depend on another table for its own identity, but is referenced by downstream fact or staging objects. It is classified as Oracle Internal Use Only; direct DML should be reserved for standard Oracle Applications programs, with read-only access used for custom reporting.

Key Information Stored

• QUARTER_ID — NUMBER, mandatory. The surrogate primary key for the quarter record. This is the column backing unique index FII_TIME_QTR_U1 (NORMAL, UNIQUE), and is therefore the documented business-key candidate for the quarter.
• YEAR_ID — NUMBER. Foreign key to the Gregorian year, joining to JAI_FA_AST_YEARS. Anchors each quarter to its parent fiscal/Gregorian year.
• NAME — VARCHAR2(100). The display label used in reports and LOVs (for example, a quarter descriptor such as a Gregorian designation).
• START_DATE / END_DATE — DATE. The inclusive boundaries of the quarter, used to bucket transactions and to derive date ranges for reporting parameters.
• PRIOR_YEAR_QUARTER_ID — NUMBER. A self-referencing pointer to the equivalent quarter in the prior year, enabling year-over-year variance and trend comparisons without date arithmetic.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN. These provide row-level audit lineage (the first four link to FND_USER.USER_ID; LAST_UPDATE_LOGIN links to FND_LOGINS.LOGIN_ID) required for EBS audit compliance.

The 11-column layout is deliberately narrow: the surrogate key (QUARTER_ID) is distinct from the natural/business key, and all temporal semantics are carried by attributes rather than embedded in the key.

Common Use Cases and Queries

Typical usage centers on date bucketing, year-over-year comparison, and reporting period definitions. A common query retrieves the quarter matching a transaction date:

• Join a fact table to FII_TIME_QTR on transaction_date BETWEEN START_DATE AND END_DATE to label transactions by quarter.
• Use the PRIOR_YEAR_QUARTER_ID self-join to compare current and prior-year quarter metrics:

SELECT c.NAME curr_qtr, p.NAME prior_qtr, c.START_DATE, p.START_DATE
FROM FII.FII_TIME_QTR c, FII.FII_TIME_QTR p
WHERE c.PRIOR_YEAR_QUARTER_ID = p.QUARTER_ID;

Other scenarios include populating concurrent program parameters, driving workbook/report layouts, and validating the completeness of the quarter calendar for a given YEAR_ID. Because the object is internal and summary-tier, reporting extracts should query it read-only and avoid modifying rows outside Oracle-supported processes.

Related Objects

• JAI_FA_AST_YEARS — referenced by FII_TIME_QTR.YEAR_ID; the parent year dimension for each quarter.
• APPS.FII_TIME_QTR — the APPS synonym/edition that references the base FII object; use this for query convenience within the APPS schema.
• FND_USER — target of CREATED_BY and LAST_UPDATED_BY foreign keys for audit resolution.
• FND_LOGINS — target of LAST_UPDATE_LOGIN for login-level audit traceability.
• FII_TIME_QTR_U1 — the unique index on QUARTER_ID that enforces surrogate-key uniqueness; its statistics affect query plans on quarter lookups.

No additional parent references are documented; the table behaves as a standalone dimension whose primary downstream role is supplying quarter context to dependent reporting objects.