Search Results fii_literal




Overview
Explore in AI Chat

Overview

The view APPS.FII_SRS_ALL_TIME_PERIODS_V is a reporting and integration construct within the Oracle E-Business Suite Financial Intelligence (FII) / Enterprise Performance Foundation data model. It presents a consolidated, human-readable list of time dimension members — periods, quarters, and years — together with a placeholder for the "N/A" literal. Its purpose is to provide a single, uniform source of time identifiers for Oracle SRS (Standard Reporting System) and other downstream reporting or extract processes that must reference time periods generically without knowing, in advance, whether a given value represents a period, a quarter, or a year.

The view is particularly relevant to users searching on the column name time_id, because that column is the generalized surrogate key that unifies identifiers originating from three separate time hierarchies. In Oracle EBS 12.1.1 and 12.2.2, this view is typically consumed by reporting tools, concurrent-program extracts, and integration loads that need a flat, de-normalized enumeration of every selectable time member, including the special "N/A" option used when no time dimension applies.

Underlying Base Objects

Although the documented ETRM metadata lists no base objects, the view text itself reveals its defining query. It is a UNION ALL-style (here implemented as UNION) composite over four sources:

The outer SELECT wraps this union and projects only four columns: NAME, TIME_ID, PERIOD_TYPE_ID, and PERIOD. Because each underlying entity uses a different primary-key column name (ENT_PERIOD_ID, ENT_QTR_ID, ENT_YEAR_ID), the union aliases them all to the common name TIME_ID.

Key Columns

  • NAME — The descriptive label of the time member (from P.NAME, Q.NAME, Y.NAME, or the lookup meaning for the N/A row). This is the value typically displayed to end users.
  • TIME_ID — The generalized surrogate key. For periods it holds FII_TIME_ENT_PERIOD.ENT_PERIOD_ID; for quarters, ENT_QTR_ID; for years, ENT_YEAR_ID; and for the N/A literal, the constant -1.
  • PERIOD_TYPE_ID — A discriminator indicating the hierarchy level: 32 for period, 64 for quarter, 128 for year, and -1 for the N/A literal.
  • PERIOD — A single-character type flag: 'P', 'Q', 'Y', or 'N/A', mirroring PERIOD_TYPE_ID.

The pairing of PERIOD_TYPE_ID and PERIOD allows callers to disambiguate TIME_ID values, since keys from different hierarchies could otherwise appear to collide.

Common Use Cases and Queries

Typical usage includes populating time selectors in reporting parameters, validating time identifiers during extract loads, and joining generic time references back to the specific enterprise entities. A basic enumeration query is:

SELECT name, time_id, period_type_id, period
FROM apps.fii_srs_all_time_periods_v
ORDER BY period_type_id, name;

To isolate only quarter members:

SELECT time_id, name
FROM apps.fii_srs_all_time_periods_v
WHERE period_type_id = 64;

To locate a specific member by its identifier when the type is already known:

SELECT name, period
FROM apps.fii_srs_all_time_periods_v
WHERE time_id = :p_time_id
AND period_type_id = 32;

These patterns are representative of how the view bridges the FII enterprise time dimension and downstream SRS reporting requirements in Oracle EBS 12.1.1 and 12.2.2.