Results for “load_rolling_offsets”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HRI_TIME_ROLLING_PKG is a PL/SQL package body owned by the APPS schema that supports the Oracle EBS HR Intelligence (HR Intelligence / HRI) time-based analytics infrastructure. Its principal business purpose is to seed and maintain the HRI_TIME_ROLLING_OFFSETS table, which stores the offset definitions used to construct rolling time periods and period-over-period comparisons in human-resource analytics reporting. By populating comparison offsets for rolling week, and by extension other rolling period types, the package enables analytical dashboards and reports to compute values such as "this week versus the same week last year" without requiring the analyst to manually derive date logic.
The package is classified in the ETRM repository as OTHER (not an end-user facing API and not a purely utility package). Its header comment indicates a version 120.0 file dated 2011, consistent with the 12.1.1 and 12.2.2 code lines, and it includes an internal debug flag driven by the profile option HRI_DEBUG_MODE, allowing diagnostic output to be toggled without code changes.
Key Procedures and Functions
The ETRM metadata documents a single procedure:
- LOAD_ROLLING_OFFSETS — Populates the rolling offset definitions in
HRI_TIME_ROLLING_OFFSETS. The procedure accepts out parameters for an error message and an error code, which follow the standard Oracle EBS error-handling convention (returning a message and status rather than raising an unhandled exception). Internally it captures the current application user viaFND_GLOBAL.USER_IDand inserts one row per rolling period definition, setting the standard WHO columns (creation_date,created_by,last_update_date,last_updated_by,last_update_login) consistently for each inserted record.
For a rolling week compared yearly, the procedure inserts offsets of 0, -7, -14, -21, and -28 days, each with a start_date_offset of -6 and a sequential period_number beginning at 0. This establishes the current period plus four prior annual equivalents.
Tables Accessed
The only documented table referenced is HRI_TIME_ROLLING_OFFSETS, accessed through the APPS synonym. The package performs insert operations exclusively in the documented excerpt; no update or delete logic is shown. Each insert records the period type (for example HRI_ROLLING_WEEK), the comparison type (for example YEARLY), the day offset, the companion start-date offset, the ordinal period number, and the audit columns. Because the procedure writes the created_by and last_updated_by columns with the runtime user ID, it must be executed under a valid EBS application session; this is the specific created_by dependency that ETRM surfaces for this object.
Usage Notes
LOAD_ROLLING_OFFSETS is a setup/reference-data loader rather than a runtime transaction handler. It is typically invoked during HR Intelligence implementation or after applying relevant patches to seed the rolling period definitions consumed by HRI analytics. Because no delete or merge logic appears in the documented source, the procedure should generally be run against an empty or validated target table to avoid duplicate offset rows. It may be invoked from a concurrent program, from SQL*Plus by a DBA, or wrapped in custom code. The referenced-by relationship (one other package) indicates it forms part of a small dependency chain within the HRI time framework. Administrators should confirm that HRI_DEBUG_MODE is set appropriately before troubleshooting, as the package gates diagnostic behavior on that profile value.