Search Results get_tax_info

Overview

HR_US_W4_EX is a PL/SQL package owned by the APPS schema that supports United States federal withholding configuration within Oracle E-Business Suite Payroll (Oracle Payroll, US legislation). Its name reflects its purpose: handling W-4-related tax information processing for US employees. In Oracle EBS 12.1.1 and 12.2.2, HRMS payroll packages of this class typically expose utility logic used to derive, validate, or retrieve employee tax withholding information needed for federal and state income tax calculation. The ETRM metadata classifies this package as API classification OTHER, indicating it is not a formally published public API such as those in the HR_API or PAY_API family. It is instead an internal or auxiliary package used by US Payroll tax processing, likely invoked during payroll runs or tax configuration maintenance. Because the package is not a documented public interface, customers should treat it as an internal implementation detail subject to change during patching or upgrade. The package is in a VALID compilation state in the referenced environment.

Key Procedures and Functions

The ETRM documentation records exactly one callable unit within this package:

• GET_TAX_INFO — Retrieves tax information for processing. Given the package name and the table set it references, this routine almost certainly reads and returns US tax-related attributes (federal and/or state withholding data) associated with an assignment or tax context, so that downstream payroll or tax calculation logic can consume it. The documented metadata does not include the parameter list, and no parameter signature should be assumed. Any customer implementation calling this routine must obtain the actual signature from the package specification in the target environment (for example, by querying ALL_ARGUMENTS or by inspecting the package spec in the database) before use.

No other documented procedures or functions are associated with this package in the ETRM metadata. The dependency section references only the STANDARD package and SYS, consistent with a relatively lightweight package that primarily performs SQL access rather than complex shared-library calls.

Tables Accessed

The documented table references, resolved through APPS synonyms, fall into functional groups that explain the package's role:

• PAY_US_FEDERAL_TAX_INFO_F and PAY_US_STATE_TAX_INFO_F — The primary US tax information entities (the "_F" suffix denotes the date-tracked base table in HRMS), holding federal and state withholding election data. GET_TAX_INFO almost certainly reads these.
• PER_ALL_ASSIGNMENTS_F — Provides the assignment context linking an employee to their payroll and tax records.
• PAY_DEFINED_BALANCES, PAY_RUN_RESULT_VALUES, and PAY_ASSIGNMENT_ACTIONS — Payroll run and balance infrastructure, indicating use during payroll processing or balance derivation.
• PAY_PAYROLL_ACTIONS and PAY_ACTION_CLASSIFICATIONS — Payroll action metadata, allowing the routine to determine the payroll context in which tax information is being requested.
• FF_DATABASE_ITEMS and FF_USER_ENTITIES — FastFormula infrastructure objects, confirming that tax information handled here ultimately feeds FastFormula-based payroll calculations.

Usage Notes

HR_US_W4_EX is not referenced by any other documented package (zero referencing packages in the ETRM metadata), and it does not appear to be a supported entry point for customer-developed code. In practice, packages of this type are invoked internally by US Payroll tax processing logic, by payroll run tax calculation code paths, or by FastFormula functions that need W-4-related data. It is not exposed through a standard concurrent program or a published form API based on the documented metadata.

Customers who encounter HR_US_W4_EX during debugging or dependency analysis should avoid direct invocation unless the signature is fully understood, because the interface is unsupported and may change between 12.1.1 and 12.2.2 or via tax patch bundles. For functional requirements such as W-4 data maintenance, the supported approach is to use the standard Oracle Payroll tax information forms and the corresponding published HRMS APIs, not this internal package. When troubleshooting payroll tax issues, tracing from the US Payroll tax calculation logic into this package can help identify where federal or state withholding values are sourced.