EAP WTHD20: Correcting TIN Number & Moving Amounts Generates Three 'A' Records In the IRS Correction File (Doc ID 2646182.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

Correcting a TIN Number and moving Amounts from one Class to another, generates three "A" Records in the IRS_001 correction file.  The third "A" Record should not generate because it references the Corrected TIN Number, original Class before amounts were moved, and zero amounts.  This additional "A" Record makes it look like the Supplier has duplicate entries in the correction file but it is not a duplicate entry.  Since amounts were never in the original Class for the new TIN Number, this third "A" Record should not generate.

This also generates three 1099 MISC Copy B forms, two with the CORRECTED box checked.  The additional 1099 MISC Copy B form with the CORRECTED box checked is for the corrected TIN Number with zero amounts.

STEPS:

ORIGINAL ENTRIES
1.  Supplier 0000000085 > Class 01 and 07 > TIN Type = F > TIN = 500000000
2.  Supplier 0000000086 > Class 06 and 07 > TIN Type = S > TIN = 600000000
3.  Supplier 0000000087 > Class 07 > TIN Type = F > TIN = 700000000
4.  Add one Voucher for each Supplier
     a.  0000000085 > Class 01 > 5000.00
     b.  0000000086 > Class 06 > 6000.00
     c.  0000000087 > Class 07 > 7000.00
     d.  Record Payment for each Voucher
5.  Payment Post
6.  Post Withholdings
7.  1099 Job
8.  IRS_001_CORP_202413.TXT...correct
     a.  0000000085 > Class 01 > 5000.00
     b.  0000000086 > Class 06 > 6000.00
9.  IRS_001_CORP_202413_ORIG_NEC.TXT > 0000000087 > Class 07 > 7000.00...correct
10.  Withholding Sent File > WTHD_SENT_DTL data correct for Suppliers
 
CORRECTIONS
1.  0000000085
     a.  Change TIN Number 500000000 to 500000001
     b.  Withholding Adjustments > move Class 01 amount to Class 07 > Legacy row 1:  Class 06 = -5000.00 > Legacy row 2:  Class 07 = 5000.00
2.  0000000086
     a.  Change TIN Type S to F
     b.  Change TIN Number 600000000 to 600000001
     c.  Withholding Adjustments > move 6000.00 from Class 06 to Class 07 > Legacy row 1:  Class 06 = -6000.00 > Legacy row 2:  Class 07 = 6000.00
3.  0000000087
     a.  Change TIN Type F to S
     b.  Change TIN Number 700000000 to 700000001
4.  1099 Job > box checked for "Has the 1099-MISC containing Box 7 Non-Employee Compensation file been sent to the IRS?"

NOTE:  In the Steps above, User Details/TIN Numbers/Company Name/Address/Email/Telephone Number, represent a fictitious sample (based upon made-up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

Cause

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