My Oracle Support Banner

Fusion Global Payroll(US): Exclude Employees from ADP Third Party Periodic & Quarterly Files (Doc ID 2142835.1)

Last updated on DECEMBER 21, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version and later
Oracle Fusion Global Payroll - Version and later
Oracle Fusion Payroll Interface Cloud Service - Version and later
Oracle Fusion Global Payroll Interface - Version and later
Information in this document applies to any platform.


Company has some international employees (Third Country Nationals Living and Working out of US) but are paid through the payroll along with the rest of the US employees. No Wages are accumulated or Taxes Withheld for these employees.

How do you make sure these employees are not included in the ADP Third Party Periodic or Quarterly files? These employees are in the US LDG along with rest of the US Based employees and have the same payroll as the US Based employees.

--- Application Configuration ---
o One Legislative Data Group: US LDG
o One Payroll Statuatory Unit: XYZ
o Two Legal Entities: XYZ and TCN Payroll LE
o Two Legal Reporting Units: XYZ (is both a TRU and Reporting establishment); TCN Payroll LE has a null in it's Legal Reporting Unit HCM information
o LRU Calculation Cards: The RTI LRU has Registrations and Calculation Cards. TCN Payroll LE does not have any registrations or calculation cards

-- Employee Configuration --
o TCN employees: Assigned to the TCN Payroll LE and the Monthly Payroll; Calculation cards are configured as exempt from all federal and regional tax withholdings
o Non-TCN employees: Assigned to the XYZ LE and the Monthly Payroll; Calculation cards allow both federal and regional withholdings

-- PASS Test Results --
o Payslips: TCN employees correctly have no tax withholdings; non-TCNs have correct withholdings
o ADPPeriodicTaxExtractEtext.txt file: tax withholding amounts are correct

-- FAIL Test Results --
o ADPQuarterlyTaxExtractEtext.txt file: TCN employee "E" records are being reported for the TCN Payroll LE

The configuration company wants to avoid is having to set the TCNs in their own payroll, which is what would be required if they had their own TRU. How can we suppress the TCN detail records from the quarterly file?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.