Search Results fii_time_api




Overview
Explore in AI Chat

Overview

APPS.FII_TIME_API is a public PL/SQL package body owned by the APPS schema that provides centralized date and time dimension resolution utilities for the Oracle E-Business Suite Enterprise Tax, Regulatory, and Reporting (ETRM) product family and its related Financial Intelligence applications. Its principal business function is to translate a given business date into the boundaries and identifiers of the applicable time dimension members across multiple calendar regimes, including enterprise calendars and the retail 4-4-5 (P445) calendar.

The package holds VALID status and is classified in the ETRM repository as an API, indicating it is intended for programmatic invocation rather than as a private implementation detail. It encapsulates the logic required to derive start dates, end dates, prior year, prior quarter, and prior period equivalents from normalized time dimension tables, thereby allowing reporting, tax determination, and period-based calculations to share one consistent definition of "current," "prior," and "year-to-date" ranges.

Key Procedures and Functions

The documented interface exposes 51 procedures and functions. They fall into several functional groupings:

Collectively these routines let a caller obtain any commonly needed comparative date range without hard-coding calendar offsets, ensuring that leap-year, 4-4-5, and enterprise-specific period rules are applied centrally.

Tables Accessed

The package reads from the FII time dimension tables exposed through APPS synonyms: FII_TIME_CAL_PERIOD, FII_TIME_CAL_QTR, FII_TIME_CAL_YEAR, FII_TIME_DAY, FII_TIME_ENT_PERIOD, FII_TIME_ENT_QTR, FII_TIME_ENT_YEAR, FII_TIME_P445, and FII_TIME_WEEK. DUAL is referenced for single-row evaluations. The calendar tables (FII_TIME_CAL_*) supply standard Gregorian period, quarter, and year members, while the enterprise tables (FII_TIME_ENT_*) supply the enterprise fiscal calendar members used for tax and regulatory reporting. FII_TIME_P445 and FII_TIME_WEEK support the retail 4-4-5 calendar and weekly bucketing. FII_TIME_DAY is used to map an individual date to its calendar and enterprise period equivalents.

Usage Notes

FII_TIME_API is consumed by 74 other database objects, indicating it is a foundational utility invoked by higher-level ETRM packages rather than called directly from a form. In practice it is invoked from concurrent programs, PL/SQL batch jobs, and custom reporting code that must align transaction dates to fiscal or enterprise periods. It also supports warehouse and OBIEE-style extract logic where consistent period labeling is required. Because it references FND_DATE, FND_FILE, and FND_MESSAGE, the package may emit messages or log output during diagnostics. The package body itself is not referenced by any database object, confirming it functions as a consumer rather than a dependency target. Custom code should call the documented subprograms instead of querying the FII_TIME_* tables directly, preserving a single supported path for calendar logic across Oracle EBS 12.1.1 and 12.2.2.