Search Results fii_time_rolling_pkg

Overview

FII_TIME_ROLLING_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API type. Its primary business function is to manage the definition and maintenance of rolling time offsets used within the Financial Intelligence / Enterprise Performance Foundation (FII) product family — specifically the time dimension management components that support analytical processing and data warehousing in Oracle EBS. Rolling offsets allow reporting periods, such as "current month," "last quarter," or "trailing twelve months," to be dynamically resolved at runtime relative to a system or user-defined reference date. This mechanism is fundamental to time-series analysis in Oracle's financial analytics and profitability solutions.

The package header carries a version identifier (§Header: FIICMT3S.pls 120.1.12000000.2), with a 2007 ship date, indicating it is a legacy but stable component carried forward through Oracle EBS 12.1.1 and 12.2.2. The "FIICMT3S" source file designation suggests it is one of a series of time/calendar management modules within the FII schema family.

Key Procedures and Functions

The package exposes a single documented procedure, LOAD_ROLLING_OFFSETS. This procedure is responsible for populating or refreshing the rolling offset definitions used by the time dimension infrastructure. It accepts two OUT parameters — an error message and an error code — a standard ETRM API convention that allows callers to detect and handle failures programmatically rather than relying on unhandled exceptions. Both parameters are declared NOCOPY for performance efficiency on large payloads.

The procedure does not return a value (it is a procedure, not a function), and no additional overloads or helper routines are documented. The loading logic is presumably driven by seed or setup data maintained by the FII time dimension configuration, ensuring that the rolling offset table reflects the currently active calendar and period definitions.

Tables Accessed

The sole documented table referenced via APPS synonym is FII_TIME_ROLLING_OFFSETS. This table stores the master definitions of rolling time offsets, including the offset type, the direction (past/future), the magnitude, and the associated calendar or period set against which offsets are resolved. LOAD_ROLLING_OFFSETS reads from and/or writes to this table to synchronize offset definitions with the broader time dimension metadata. Dependencies on this package are also indirect: the ETRM documents that FII_TIME_ROLLING_PKG is referenced by one other package, meaning its output (the loaded offset data) is consumed downstream by additional FII time-processing logic.

Usage Notes

Because this is an "OTHER"-classified API with only a single procedure and OUT-parameter error handling, it is best understood as an internal maintenance routine rather than a public extension point. Typical invocation scenarios include:

• Concurrent programs or setup routines executed during FII time dimension configuration or periodic calendar refresh, ensuring rolling offsets remain consistent with the active period definitions.
• Called by another FII package (documented as one dependent package) that orchestrates time-dimension setup steps in sequence.
• Custom code or migration scripts that need to force a reload of rolling offset definitions after calendar changes, provided the caller implements appropriate error-message and error-code handling.

Developers should treat LOAD_ROLLING_OFFSETS as a stateful, batch-oriented operation. It should not be called inside row-level triggers or frequent transaction loops, as it likely truncates and repopulates the FII_TIME_ROLLING_OFFSETS table. Always check the OUT error code before proceeding, and avoid direct DML against the offset table in favor of this package to preserve referential integrity with the time dimension framework.