Search Results hr_us_w2_rep




Overview
Explore in AI Chat

Overview

APPS.HR_US_W2_REP is a PL/SQL package body in Oracle E-Business Suite that supports the generation and reporting of United States W-2 wage and tax statements. As its name indicates, the package is dedicated to the W-2 reporting process within Oracle Payroll and Oracle Human Resources. The package operates against Oracle Fast Formula infrastructure (FF tables), HR organization and location tables, and payroll tax unit data to assemble the specific statutory values required on a federal or state W-2 form. It follows the standard EBS architectural pattern in which a reporting package retrieves, formats, and archives reporting elements for downstream printing and electronic filing. In ETRM 12.1.1 and 12.2.2 it is classified as an OTHER API type, VALID in the APPS schema, and is referenced by 35 other database objects, indicating a foundational role in the W-2 subsystem.

Key Procedures and Functions

The package exposes 28 documented procedures and functions, the majority of which are specialized getters that extract a single W-2 field or attribute for a given employee, tax unit, or reporting context:

Collectively these routines provide the field-level access layer necessary to construct a complete W-2 record.

Tables Accessed

The package reads from both Fast Formula metadata and core HR/Payroll tables. The FF tables — FF_ARCHIVE_ITEMS, FF_ARCHIVE_ITEM_CONTEXTS, FF_CONTEXTS, FF_DATABASE_ITEMS, and FF_USER_ENTITIES — are used to identify archived formula items and their contexts, enabling retrieval of reporting values derived from Fast Formulas. FND_LOOKUP_VALUES supplies lookup code values. HR_LOCATIONS_ALL, HR_ORGANIZATION_INFORMATION, and HR_ORGANIZATION_UNITS provide location and organization details. PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, and PER_ADDRESSES supply employee, assignment, and address data. PAY_US_COUNTY_TAX_INFO_F, PAY_JOB_WC_CODE_USAGES, PAY_US_W2_TAX_UNIT_V, and PAY_ASSIGNMENT_ACTIONS support payroll tax unit, county tax, and assignment action retrieval. Utility calls to HR_UTILITY and FND_NUMBER provide supporting conversions and lookups.

Usage Notes

HR_US_W2_REP is typically invoked indirectly by Oracle Payroll's W-2 reporting concurrent programs and by the W-2 forms/magnetic media processes rather than called directly by end users. Because it is referenced by 35 other packages, it functions as a shared utility layer within the US payroll reporting stack. Customizations that extend or replace standard W-2 output commonly call individual getter functions to obtain specific field values without re-implementing the underlying Fast Formula or HR queries. The package is not referenced by any database object outside APPS, confirming it is an internal reporting component of the EBS application schema and does not constitute a public integration API.