Results for “hri_gain_types”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EDW_HR_MVMNT_TYP_M_SIZING is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API. Its name follows the naming convention used by Oracle's Human Resources Intelligence (HRMSi / Daily Business Intelligence) extraction layer, in which the "EDW_" prefix denotes Enterprise Data Warehouse staging logic and the "_SIZING" suffix denotes routines that estimate the volume and width of data that a warehouse collection program will process.

The package supports the HR movement type dimension, one of the conformed dimensions used in Oracle HRMS analytics. Before a daily or periodic warehouse collection executes, the sizing package is queried to determine how many source rows qualify for the requested date window and what average row length those rows exhibit. These two figures let the collection framework allocate array sizes, predict tablespace growth, and warn administrators when a load will exceed configured thresholds. In EBS 12.1.1 and 12.2.2 the package is part of the seeded HRMSi schema footprint and is not intended for direct customer modification.

Key Procedures and Functions

The package exposes two documented procedures, both declared in the package specification and therefore callable from outside the package body.

• COUNT_SOURCE_ROWS — Accepts a source date range and returns the number of rows that would be extracted for the movement type dimension within that window. The result is returned through an OUT parameter and is used by the warehouse collection framework to size processing arrays and to estimate the runtime of the extraction step.
• ESTIMATE_ROW_LENGTH — Accepts the same date range and returns the computed average row length, also through an OUT parameter. This value is combined with the row count to project the total byte volume the extraction will generate, which in turn informs temporary segment sizing and load-planning decisions.

Both procedures follow the standard sizing-package contract: a FROM_DATE lower bound, a TO_DATE upper bound, and a single numeric output. The package specification carries no other public subprograms, and the header comment identifies the source file as hriezmvt.pkh, confirming it as a seeded HRMSi object rather than a custom extension.

Tables Accessed

The package reads from three documented objects, all referenced through APPS synonyms.

• EDW_LOCAL_INSTANCE — Identifies the local warehouse instance. This table establishes the context in which sizing statistics are computed, ensuring that estimates correspond to the instance executing the collection.
• HRI_EDW_EVENT_HRCHYS — Stores HR event hierarchies used to classify HR movements. The sizing logic consults this table to determine which hierarchy members qualify as movement types for the requested date range.
• HRI_EDW_EVENT_HRCHY_CMBNS — Holds the hierarchy combinations that map event hierarchies into dimension members. It supplies the combination detail needed to resolve movement type rows during counting and length estimation.

No insert, update, or delete activity is documented; the package behaves as a read-only metadata and measurement utility.

Usage Notes

EDW_HR_MVMNT_TYP_M_SIZING is invoked by the HRMSi warehouse collection infrastructure rather than by end users. Typical invocation paths include the concurrent programs that populate the HR movement type dimension, which call the sizing procedures in a preliminary pass before launching the main extraction. Administrators running "Collect" style concurrent requests indirectly trigger these procedures. Oracle does not document direct calls from Oracle Forms, and the package is not referenced by any other documented package, so custom code should treat it as an internal dependency of the seeded collection framework. Because the results feed allocation and scheduling logic, the procedures should not be modified; customizations should instead target the underlying hierarchy tables or the collection program parameters.