Search Results fii_rolling_week

Overview

The APPS.FII_TIME_ROLLING_PKG package body is a component of the Oracle E-Business Suite Financial Intelligence (FII) product family, which supplies the analytical and reporting infrastructure used by Oracle Financial Analyzer, Oracle Daily Business Intelligence, and related financial reporting tools. Its principal business function is to define and maintain the rolling time-period definitions that drive period-over-period comparisons in financial reports and dashboards. In particular, it supports the concept of a rolling year (and rolling week) by populating offset records that describe how historical periods—such as prior weeks, months, or years—are mapped against a current reporting period.

The package header comment ($Header: FIICMT3B.pls 120.1.12000000.1 2007/01/18) indicates that this object dates to the early FII codebase and has remained stable across releases. It is a data-seeding and configuration utility rather than a transactional API, and it is classified under the generic "OTHER" API classification in the ETRM metadata.

Key Procedures and Functions

The package body exposes a single documented procedure:

• LOAD_ROLLING_OFFSETS — This procedure seeds the FII_TIME_ROLLING_OFFSETS table with the set of period offsets that define rolling comparison windows. For each period type (for example, FII_ROLLING_WEEK) and comparison type (for example, YEARLY), the procedure inserts a series of rows carrying an offset, a start-date offset, and a period number. As shown in the source excerpt, the weekly/yearly series generates offsets of 0, -7, -14, -21 and -28 days with corresponding period numbers 0 through 4, and a constant start-date offset of -6. The procedure returns an error message and error code through its OUT parameters, allowing callers to detect and handle load failures. It captures the executing user via FND_GLOBAL.USER_ID and stamps WHO columns on every inserted row.

No other procedures or functions are documented for this package body. The procedure deliberately avoids inventing or hard-coding dynamic logic; the offsets are static literals that represent the standard FII rolling calendar definitions.

Tables Accessed

• FII_TIME_ROLLING_OFFSETS — The sole documented table referenced by this package (accessed through the APPS synonym). It stores the period type, comparison type, offset, start-date offset, and period number used by the FII reporting engine to resolve relative time periods. LOAD_ROLLING_OFFSETS performs insert-only operations against this table.

No updates or deletes are documented, implying that routine execution is expected against an empty or freshly purged table, or that duplicate-prevention is handled by the caller.

Usage Notes

Because the package is a seed/utility routine, it is typically invoked during implementation setup, after patching, or when initializing a new FII reporting configuration. Practical invocation paths include:

• Custom concurrent programs or SQL*Plus scripts run by a DBA or implementation consultant to initialize rolling period definitions.
• Setup or installation routines that prepare the FII time dimension prior to running financial reports.
• Custom PL/SQL code in customer extensions that need to refresh or repopulate the offsets table after period-type changes.

The package is referenced by one other package, indicating it is part of a small dependency chain within the FII time utilities. The debug flag (g_debug_flag) is initialized from the FII_DEBUG_MODE profile option, providing trace output when troubleshooting. The fii_rolling_year search term is consistent with the package's role: it manages rolling-year and rolling-week comparison offsets that users configure when defining annualized financial comparison reports.