Search Results transfer_gre

Overview

APPS.PAY_US_W2_TAX_UNIT_V is a legislative reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes United States W-2 tax unit data captured against payroll actions. Its primary role is to support federal and state year-end reporting by resolving tax unit identity, employer identification details, and address information at the level of an individual payroll action. The view is characteristic of Oracle Payroll's US legislative model, in which a payroll action may group employees under a single tax unit (a legal employer or reporting entity) for W-2 purposes.

Because tax unit information is not stored in a simple relational table but is encoded in the legislative parameters of the payroll action, the view performs string parsing and package-driven lookups to present flat, queryable columns. This makes the object suitable for reporting tools, interfaces, and year-end extracts that must reconcile W-2 forms to a specific tax unit without traversing the underlying configuration.

Underlying Base Objects

The documented base objects for this view are the HR_US_W2_REP package and the PAY_PAYROLL_ACTIONS synonym.

• HR_US_W2_REP — a US legislative package that supplies the transformation logic. The view relies on functions such as get_tax_unit_bg, get_w2_tax_unit_item, and get_tax_unit_addr_line to derive the business group, tax unit attributes, and address lines from a parsed tax unit identifier.
• PAY_PAYROLL_ACTIONS — the synonym over the payroll actions table, which provides the payroll_action_id, the legislative_parameters column, and the effective_date used to derive the reporting year.

The pivotal column referenced by the user search, legislative_parameters, is a delimited string held on the payroll action record. The view locates the substring 'TRANSFER_GRE=' within that string and extracts the trailing numeric value to obtain tax_unit_id.

Key Columns

• year — the four-digit year derived from effective_date, used to associate records with a reporting period.
• tax_unit_id — the tax unit identifier parsed from legislative_parameters after the TRANSFER_GRE= token.
• business_group_id — the business group returned by get_tax_unit_bg for the resolved tax unit.
• federal_ein — the employer identification number for the tax unit; defaults to 'Applied For' when none is defined.
• tax_unit_name — the descriptive name of the tax unit, retrieved via get_w2_tax_unit_item.
• address_line_1, address_line_2, address_line_3, town_or_city, state, country — address components returned by get_tax_unit_addr_line for the tax unit, suitable for W-2 Box formatting.

Common Use Cases and Queries

This view is typically queried during year-end processing and for auditing tax unit assignment across payroll actions.

• Confirming the federal EIN and tax unit name applied to each payroll action in a reporting year.
• Extracting W-2 address blocks for tax units to validate form output.
• Reconciling payroll actions to business groups for multi-entity reporting.

A representative query:

SELECT year, tax_unit_id, business_group_id, federal_ein, tax_unit_name, town_or_city, state FROM apps.pay_us_w2_tax_unit_v WHERE year = 2024;

Because the columns are produced through parsing and package calls, query performance depends on the volume of payroll actions scanned and the cost of the HR_US_W2_REP functions. Filtering by year is advisable to limit the effective_date range evaluated by the view.