Search Results worker_type_lvl1




Overview
Explore in AI Chat

Overview

HRI_OPL_PERSON_TYPE_CTGRY is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified under the ETRM as OTHER. Its principal business function is to populate and maintain the person type category collection table that supports the Oracle HRMS Intelligence (Daily Business Intelligence) reporting layer. The package resolves the categorization and data-restriction requirements originally raised in bug 3829100, allowing customers to govern which person records appear in DBI subject areas by classifying person types into reporting categories.

The mechanism operates through a user-defined QuickPaint fast formula named HRI_MAP_PERSON_TYPE, defined at the Global level in the setup business group and optionally overridden per business group. The formula consumes the system person type, user person type, primary flag, and employment category as inputs, and returns INCLUDE_IN_REPORTS (Y/N), WORKER_TYPE, WORKER_TYPE_LVL1, and WORKER_TYPE_LVL2. The WORKER_TYPE outputs are derived from the HRI_CL_WKTH_WKTYP, HRI_CL_WKTH_LVL1, and HRI_CL_WKTH_LVL2 lookups. This design lets implementers categorize Employee and Contingent Worker person types to match their own configuration and exclude selected person types from reporting entirely by returning 'N' for INCLUDE_IN_REPORTS.

Key Procedures and Functions

The package exposes two documented entry points, both oriented toward maintaining the person type category collection:

  • FULL_REFRESH — Performs a complete rebuild of the person type category data. It is the appropriate entry point when the collection has never been built, when the HRI_MAP_PERSON_TYPE formula or the underlying lookups have changed substantially, or when data integrity of the collection is in question.
  • INCR_REFRESH — Performs an incremental refresh that processes only changed or newly added person type data since the previous collection run. It is typically scheduled more frequently than the full refresh to keep the DBI reporting tables current without the cost of a complete rebuild.

The package body additionally contains internal helper constructs, including a logging routine (OUTPUT) that writes diagnostic text to the concurrent program log through HRI_BPL_CONC_LOG.output, and simple index-by tables for NUMBER and VARCHAR2 values used during processing. These helpers are not part of the documented public interface.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

  • HRI_CS_PRSNTYP_CT — The person type category collection table that this package populates and refreshes; the central target of both refresh procedures.
  • HRI_CS_GEO_LOCHR_CT — A geography/location hierarchy collection referenced during collection processing.
  • HRI_EQ_ASG_SUP_WRFC — A workforce collection used in the assignment and supervisor context.
  • PER_PERSON_TYPES — The base Oracle HRMS person type definition table, providing the system person types that are categorized.
  • DUAL — Used for single-row PL/SQL evaluations and formula invocation scaffolding.
  • PLITBLM — The standard PL/SQL index-by table of VARCHAR2 used for passing collections to and from the fast formula engine.

Usage Notes

This package is not intended for direct invocation by end users. It is normally driven by the Oracle HRMS Intelligence collection concurrent programs, which invoke FULL_REFRESH or INCR_REFRESH on the appropriate schedule. Administrators configure the categorization behavior exclusively through the HRI_MAP_PERSON_TYPE QuickPaint fast formula rather than by modifying package code. When implementing or troubleshooting DBI person type reporting, the standard sequence is to define or revise the formula, run FULL_REFRESH to rebuild the collection, and thereafter rely on INCR_REFRESH. Custom code should call the documented procedures only, avoid dependencies on the internal helper routines, and always inspect the concurrent program log output for formula compilation or data errors. The package is referenced by one other database package, reinforcing its role as a shared collection component within the HRMS Intelligence schema.