Search Results per_us_hr_utility_pkg




Overview
Explore in AI Chat

Overview

PER_US_HR_UTILITY_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API type rather than a standard public interface. Its business purpose is to support United States–specific statutory and regulatory human resources reporting, most notably the derivation of race and ethnicity data required by U.S. Equal Employment Opportunity (EEO) and federal reporting obligations. The package encapsulates the logic Oracle HRMS uses to translate the multiple-race and ethnicity category responses captured for U.S. employees into the single, consolidated values expected on U.S. federal reports such as the EEO-1 survey and related workforce analytics.

The package body is recorded with a VALID status in both Oracle EBS 12.1.1 and 12.2.2 environments, and ETRM documents it as referencing and being referenced by other objects. It is not exposed as a public, customer-facing API; rather it functions as internal utility code consumed by other HRMS packages and, in some cases, by person extra information processing.

Key Procedures and Functions

The documented metadata lists two program units inside the package body. Parameter lists are not enumerated in the ETRM excerpt, so only their purpose is described here:

  • DERIVE_ALIEN_ETHNIC_ORIGIN — Derives the ethnicity or national origin attribute associated with employees whose records carry alien (non-citizen) or related foreign-nationality designations. This supports U.S. regulatory classification of workers by origin where an employee's records indicate non-U.S. origin status.
  • DERIVE_SINGLE_RACE — Consolidates multiple recorded race selections for a person into a single race value, applying the precedence and combination rules that U.S. federal reporting and Oracle HRMS require. This is the utility used to satisfy the "single race" expectation on EEO and similar reports where employees may have self-identified with more than one race category.

Both procedures operate as internal derivation helpers and are not intended to be called directly by end users.

Tables Accessed

According to the documented dependency information, PER_US_HR_UTILITY_PKG reads from APPS.PER_PEOPLE_EXTRA_INFO (accessed via the APPS synonym). PER_PEOPLE_EXTRA_INFO is the descriptive-flexfield–style table that stores person-level extra information, including the U.S. legislative data elements such as race, ethnicity, and related statutory attributes captured on the Person Extra Information form. The package reads these stored responses and transforms them into derived values; the read access supports both DERIVE_SINGLE_RACE and DERIVE_ALIEN_ETHNIC_ORIGIN. The ETRM metadata records only this single table reference for the package body, indicating the derivation logic is driven entirely by the extra information records.

Usage Notes

PER_US_HR_UTILITY_PKG is an internal package that is not referenced by any database object in the ETRM dependency listing, meaning it is not called from other stored PL/SQL units. Instead, its procedures are typically invoked from Oracle Forms, most plausibly the Person Extra Information maintenance forms and U.S. HRMS legislative data forms, as well as from related HRMS processing that needs consolidated race or ethnicity values. Oracle documentation notes that the package references the FND_DATE utility package and STANDARD, consistent with date formatting and standard PL/SQL conventions used internally.

Because the documented metadata records "Referenced by 12 other packages" and an API classification of OTHER, the package should be treated as internal utility code. Customers who require derived race or ethnicity values in custom reports or interfaces should generally rely on the supported HRMS views and APIs that expose person extra information rather than calling PER_US_HR_UTILITY_PKG procedures directly, since its signature and behavior are not part of a published interface and may change between releases without notice. When troubleshooting U.S. race or ethnicity reporting discrepancies, the package and its source table PER_PEOPLE_EXTRA_INFO are the appropriate starting points for investigation.