EAP WTHD15: Withhold 1099 Report (AP_APY1099) abends at Step AP_APY1099.COPYB100.InsCopyb (SQL) -- RC = 805 for 1099-INT Correction File (Doc ID 2079442.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Withhold 1099 Report (AP_APY1099) abends at Step AP_APY1099.COPYB100.InsCopyb with an error. 

This issue only occurs if trying to create a Correction file for 1099-INT. 

After running the Withholding Sent File process then making a change to Address 1 for a 1099 Vendor, once Withhold 1099 Report is run again, the error will occur.

ERROR
Return: 805 - ORA-00001: unique constraint (EMDBO.PS_WTHD_1099_COPYB) violated

Process ABENDED at Step AP_APY1099.COPYB100.InsCopyb (SQL) -- RC = 805

STEPS
1.  Created Vouchers for 1099 Vendors
2.  Pay the Vouchers
3.  Run Payment Posting
4.  Run Post Withholding
5.  Run Withhold 1099 Report Post
6.  Run Withhold 1099 Report
7.  Run Withhold 1099 Copy B Sort
8.  Print 1099 Copy B's
9.  Run Withholding Sent File
10.  Update Address 1 for one of the 1099 Vendors that will create a 1099-INT
11.  Run Withhold 1099 Report Post
12.  Run Withhold 1099 Report
13.  Process will abend at Step AP_APY1099.COPYB100.InsCopyb with the above error

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms