Search Results hr_us_reports




Overview
Explore in AI Chat

Overview

HR_US_REPORTS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, validated across releases 12.1.1 and 12.2.2. It serves as the core data-retrieval layer for United States–specific statutory and regulatory reporting generated by Oracle HRMS and Oracle Payroll. Rather than producing formatted output directly, the package supplies the query and lookup primitives that US reporting concurrent programs and forms rely upon to assemble paycheck details, payroll balance extracts, new-hire reporting, COBRA/benefits compliance output, and audit listings.

The package is classified as OTHER rather than as a public API, indicating that it is an internal implementation object intended for Oracle's own delivered reports and supported custom extensions. It exposes 33 documented procedures and functions and is itself referenced by ten other packages, confirming its role as a shared utility tier. The dependency list shows heavy integration across three product families — Oracle HR (PER/HR), Oracle Payroll (PAY), and Oracle Advanced Benefits (BEN) — along with Oracle Spatial geometry types for address and geographic processing.

Key Procedures and Functions

The documented entry points fall into distinct functional groups, each oriented toward a reporting use case:

Tables Accessed

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

Usage Notes

HR_US_REPORTS is not designed for direct end-user invocation. It is typically called from US statutory reporting concurrent programs, from HRMS forms that display US reporting attributes, and from Oracle-delivered report templates that require pre-resolved payroll, benefit, and address values. Because the package is a supporting object rather than a public API, its procedure signatures and behavior are not guaranteed stable across patches; custom code referencing it should be treated as an unsupported extension and validated against each applied patch or upgrade. When diagnosing US reporting output, this package is a primary point of inspection because it frequently appears in the call stack of the report programs that consume its GET_* and FNC_GET_* functions.