Search Results hri_oltp_conc_dim




Overview
Explore in AI Chat

Overview

HRI_OLTP_CONC_DIM is an Oracle Applications (APPS) PL/SQL package that belongs to the Oracle Human Resources Intelligence (HRI) OLTP collection. Its purpose is to build and refresh the dimension tables used by Oracle HRMS business intelligence and analytics reporting. In the dimensional model that underpins HRMS reporting, "DIM" denotes a dimension table (as opposed to a fact table), and "CONC" refers to the concurrent, snapshot-style loading of these dimensional structures. The package therefore serves as the extract-and-load layer that populates HR organizational, positional, and workforce dimensions from the transactional HRMS tables so that downstream analytical queries and dashboards operate against pre-aggregated, denormalized structures rather than live transactional data.

Within Release 12.1.1 and 12.2.2, the package is registered in the APPS schema with a VALID status and is classified under the ETRM API classification "OTHER." It is a self-contained loader with no dependency on other application packages, which simplifies its deployment and patching behavior.

Key Procedures and Functions

The ETRM metadata documents nine public procedures, each responsible for loading a specific dimension. Their names are self-describing with respect to the HRMS entity being processed:

  • LOAD_SUPERVISOR_HISTORY — populates the supervisor hierarchy history dimension, capturing reporting-line relationships over time.
  • LOAD_ALL_POSITIONS — loads the positions dimension from the HR positions repository.
  • LOAD_ALL_ORGANIZATIONS — loads the organization dimension, including organization hierarchies and classifications.
  • LOAD_ALL_JOBS — loads the jobs dimension from the HR jobs repository.
  • LOAD_ALL_PERSON_TYPES — loads the person type dimension, covering employee, applicant, and contingent worker classifications.
  • LOAD_ALL_PERSONS — loads the person dimension, the primary workforce dimension used by most HRMS analytics.
  • LOAD_ALL_POW_BANDS — loads the "period of work" or position-related band dimension.
  • LOAD_ALL_JOB_JOB_ROLES — loads the job-to-job-role association dimension, linking jobs with their assigned roles.

Each procedure follows a consistent all-rows reload pattern, as indicated by the "LOAD_ALL_" naming convention. Parameter lists are not exposed in the ETRM documentation and should not be assumed; the procedures are intended to be invoked as documented loaders.

Tables Accessed

The ETRM excerpt does not enumerate the underlying transactional tables, because the package reads source data exclusively through APPS synonyms. Based on its documented procedures, the package reads from the core HRMS tables behind the positions, organizations, jobs, person types, persons, and job-role entities, and writes to the corresponding HRI_OLTP_CONC_* dimension tables. The absence of explicitly listed tables in the metadata means referential validation should be performed against the actual package body before customization.

Usage Notes

HRI_OLTP_CONC_DIM is designed to be driven by concurrent programs rather than by interactive forms. The most common invocation paths are:

  • Standard Oracle HRMS Intelligence concurrent programs that refresh the OLTP dimension tables on a scheduled basis, typically nightly or at a frequency aligned with the reporting latency requirement.
  • Manual submission via the Concurrent Programs form by administrators performing an on-demand refresh after significant HRMS data changes, such as a reorganization or mass hire event.
  • Custom code invoking the loaders directly when a bespoke analytics solution requires dimension rebuilds outside the standard schedule.

Because the package performs full reloads of each dimension, it should be scheduled during periods of low transactional activity to avoid contention on the source HRMS tables. Dependent reports and dashboards will reflect stale data until all loaders complete, so sequencing the individual procedures (persons, then organizations, then jobs and positions, then the association dimensions such as job roles and supervisor history) is advisable. The package has no reverse dependencies on other APPS packages, minimizing the risk that patches to unrelated modules will invalidate it.