EAP WTHD: 1099 CORRECTION FORM 1099 MISC FOR 2020 NOT SHOWING THE CORRECT INFORMATION ON COPYB (Doc ID 2836219.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Symptoms

ISSUE:

1099 Correction form 1099MISC for 2020 not showing the correct information on copyb.

When correction for 2020 are processed, the copyb (APX1099CT - APX1099CT.pdf ) is not showing the old template information. It takes the template information for 2021.

STEPS:

1. Take Existing data for 2020 - Supplier - USA0000018
2. Check data in the ps_wthd_to_snd_hdr table

select * from ps_wthd_to_snd_hdr
where fiscal_year = '2020'

3. Check data in the ps_wthd_to_snd_dtl table

select * from ps_wthd_to_snd_dtl
where fiscal_year = '2020'

4. Run 1099 sent process
  Main Menu > Suppliers > 1099/Global Withholding> 1099 Reports >
Withholding Sent File
  
5. Check data in the ps_wthd_sent_hdr table
select * from ps_wthd_sent_hdr
  
6. Check data in the ps_wthd_sent_dtl table
select * from ps_wthd_sent_dtl
  
7. Now do corrections for 2020
Main Menu > Suppliers > 1099/Global Withholding > Maintain > Adjust
Withholding

Added 3rd row

8. Check data in the ps_wthd_trxn_tbl
select wthd_basis_amt, a.*
from ps_wthd_trxn_tbl a
where pymnt_dt >= '01-JAN-2020' and pymnt_dt <= '31-DEC-2020'

9. Now run the 1099 job
Main Menu > Suppliers > 1099/Global Withholding > 1099 Reports > Withhold
1099 Report Job

Process went to success
Form 1099-MISC shows Miscellaneous Information instead of Miscellaneous
Income


Also Box 11 was new in 2021 but it still showing for 2020.
App Engine APX1099 shows step02 as <2020

Cause

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