Search Results pay_us_w2c_in_mmref2_format




Overview
Explore in AI Chat

Overview

PAY_US_MMRF2_W2C_FORMAT_RECORD is an Oracle EBS PL/SQL package owned by the APPS schema that supports the generation of United States W-2C (corrected wage and tax statement) magnetic media reporting. It belongs to the MMRF2 (Magnetic Media Reporting Format 2) family of packages used by Oracle Payroll to produce the electronic file layouts required by the Social Security Administration for W-2/W-2C submission. The package is classified as OTHER in the ETRM registry, meaning it is an internal utility rather than a published business API, and it is not intended for direct customer invocation.

The package's role is to take payroll balance and tax information extracted from Oracle Payroll and render it into the fixed-position record formats that comprise the MMREF-2 electronic file. Each documented procedure produces one specific record type within the file structure.

Key Procedures and Functions

The ETRM metadata documents seven procedures in this package, each named for the MMREF-2 record type it formats:

Importantly, the package name embedded in the object (MMRF2_W2C) together with the "W2C" prefix in each procedure indicates that these routines are dedicated to corrected statements rather than original W-2 output. No parameter lists are documented and none should be assumed.

Tables Accessed

According to the ETRM metadata, the package references two tables through APPS synonyms:

  • PAY_US_FEDERAL_TAX_INFO_F — the federal tax information table that stores the employee's federal tax data, including filing status, exemptions, and other attributes required for W-2/W-2C reporting.
  • PLITBLM — a standard Oracle Payroll PL/SQL table used for passing collections of records into and out of payroll formatter routines. Its appearance here is consistent with the package functioning as a formatter invoked inside the payroll reporting pipeline.

The dependency information additionally shows that PAY_US_MMRF2_W2C_FORMAT_RECORD references PAY_US_W2C_IN_MMREF2_FORMAT, and is itself referenced by that same package, indicating a bidirectional relationship where PAY_US_W2C_IN_MMREF2_FORMAT is the driver that calls the formatter procedures. This package is referenced by one other package overall.

Usage Notes

This package is not a public API and should not be called directly from custom code. It is invoked indirectly when a user runs the US W-2C magnetic media reporting process, most commonly via the "Magnetic Media" concurrent program in Oracle Payroll or through the corresponding payroll reporting form. The driver package PAY_US_W2C_IN_MMREF2_FORMAT calls the individual FORMAT_W2C_RC*_RECORD procedures for each record type in the MMREF-2 layout, passing the payroll data retrieved from PAY_US_FEDERAL_TAX_INFO_F.

Because the procedures manipulate tax data used on corrected statements, they run only after the correction processing has completed and the corrected balances exist in the Payroll tables. Oracle exposes no supported entry point into this package for customer extensions; any customization should be performed against the W-2C conversion or post-processing layers rather than the formatter itself. The status recorded in ETRM is VALID, and this state should be confirmed in the specific patch level of EBS 12.1.1 or 12.2.2 in use, since Oracle Payroll tax formatter packages are frequently replaced by patch updates.