Search Results format_w2_rf_record




Overview
Explore in AI Chat

Overview

The APPS.PAY_US_MMRF_W2_FORMAT_RECORD package body is a US legislative reporting utility within Oracle E-Business Suite Payroll. Its documented purpose is to format records required for the generation of W-2 magnetic tape (MMREF) files in accordance with United States federal and state tax reporting requirements. The package assembles fixed-position records used by magnetic media filers, including the RA, RV, RE, RW, RO, RS, RT, RU, and RF record types specified by the Social Security Administration's MMREF format.

Classification in ETRM is OTHER, indicating a non-public internal utility rather than a callable business API. It is referenced by the package PAY_US_REPORTING_UTILS_PKG, which acts as the primary consumer of its formatting functions. The package body carries a header revision identifier of pyusw2fr.pkb 120.47.12010000.4, consistent with Oracle EBS 12.1.1 and 12.2.2 file versioning conventions.

Key Procedures and Functions

The package exposes thirteen documented program units, each responsible for constructing or validating a specific portion of the MMREF output:

  • SET_REQ_FIELD_LENGTH — establishes required field lengths and performs blank or zero filling; the package history records modifications for W-2c magnetic media requirements.
  • FORMAT_W2_CONTACT_PRSN_INFO — formats contact person data included in the submitter or transmitter portions of the file.
  • FORMAT_MMREF_ADDRESS — standardizes address elements such as delivery address, city, state, and ZIP code for MMREF output.
  • FORMAT_W2_RA_RECORD — formats the RA (submitter) record, with history noting NR blank fill across positions 12–216, 274–295, and 356–512.
  • FORMAT_W2_RV_RECORD — formats the RV record used within the MMREF record hierarchy.
  • FORMAT_W2_RE_RECORD — formats the RE (employee) record, applying blank fill at positions 7, 17–39, 97–118, and 179–512.
  • FORMAT_W2_RW_RECORD — formats the RW record type.
  • FORMAT_W2_RO_RECORD — formats the RO record type.
  • FORMAT_W2_RS_RECORD — formats the RS (state) record; defect history records the correction of an uninitialized l_last_field variable that had produced an erroneous 487-position length. State-specific formatting changes for Maryland, Kansas City (MO), and Louisiana are documented here.
  • FORMAT_W2_RT_RECORD — formats the RT record type.
  • FORMAT_W2_RU_RECORD — formats the RU record type.
  • FORMAT_W2_RF_RECORD — formats the RF (final) record type.

Tables Accessed

ETRM documents a single table reference via APPS synonym: PAY_US_FEDERAL_TAX_INFO_F. This table supplies federal tax information required to populate W-2 reporting fields, including employer identification data and related federal tax attributes used during record assembly.

Usage Notes

The package is not intended for direct invocation by end users. It is invoked indirectly by PAY_US_REPORTING_UTILS_PKG, which is itself driven by the US Payroll year-end reporting concurrent programs that produce W-2 magnetic media output. Two dependent packages reference it in the documented dependency chain. Customizations should avoid re-implementing MMREF record logic, as the fixed-position layouts are strictly legislated and subject to periodic Oracle patches. The extensive defect history — spanning revisions 115.0 through 115.11 — reflects frequent state-specific corrections, and customers should ensure the latest patch level for their EBS release is applied before year-end processing.