My Oracle Support Banner

EAP WTHD19: The 1099_RPT_PST AE Process Picking Up Inactive Supplier Address for the 1099 Reporting. (Doc ID 2648092.1)

Last updated on MARCH 20, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


The 1099 Report Post (1099_RPT_PST)  AE process picking up inactive Supplier Address for the 1099 reporting.

STEPS:

1. Supplier Setup

Loc 001

eff dt 04/03/2018 - active - 1099 pointing to address seq 1
eff dt 10/03/2017 - active - 1099 pointing to address seq 2
eff dt 01/01/1900 - active - 1099 pointing to address seq 1

Address 1

eff dt -04/03/2018 - active
eff dt -01/17/2013 - active
eff dt -01/01/1900 - active

Address 2

eff dt -04/03/2018 - in active
eff dt 04/03/2013 - active

Adjust withholding done for 2 transactions

1. 01-FEB-2018 - 1000 - address 1
2. 01-MAY-2018 - 2000 - address 1

1. Supplier  USA1099001       

Address 1

Eff Dt  04/03/2018 - Active  
Eff Dt  01/17/2013 - Active     
Eff Dt  04/03/2018 - Active   
  
Address 2

Eff Dt  04/03/2018  In Active     
Eff Dt  04/03/2013  Active
Location 1 has 3 eff dated rows

04/03/2018- Active -Pointing to address seq 1 
10/03/2017- Active -Pointing to address seq 2
01/01/1900- Active -Pointing to address seq 1

 2. Check Data in the ps_vendor_wthd

select * from ps_vendor_wthd
where vendor_id ='USA1099001'
 
3. Create 2 Adjust withholding transactions

4. Check Data in the wthd_trxn_tbl

select * from ps_wthd_trxn_tbl
where vendor_id ='USA1099001'
and pymnt_dt >'01-JAN-2018' and pymnt_dt  < '31-DEC-2018'

5.Run 1099 Report Post

6. Check Data in the wthd_1099_tbl

select  vndr_loc, address_seq_num, wthd_basis_amt
from PS_WTHD_1099_TBL
where vendor_id ='USA1099001'
 
7.Run 1099 Report Process

8.Run Print 1099 CopyB job
 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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