My Oracle Support Banner

EAP WTHD21: 1099_RPT_PST Process Fails Due to Unique Constraint Error at Step 1099_RPT_PST.PreProc.Step01 (SQL) (Doc ID 2826905.1)

Last updated on FEBRUARY 21, 2023

Applies to:

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


1099_RPT_PST process fails due to unique constraint error.

1) Withholding Entity has 2 different effective dates and 2 different Min. Amt. thresholds.
Navigation:  Set Up Financials/Supply Chain > Product Related > Procurement Options > Withholding > Withholding Entities > Withholding Entity
2) Create a 1099 applicable voucher.
Navigation: Accounts Payable > Vouchers > Add/Update > Regular Entry
3) Post the voucher.
Navigation: Accounts Payable > Batch Processes > Vouchers > Voucher Posting > Voucher Posting Request
4) Pay the voucher.
5) Post the payment.
Navigation: Accounts Payable > Batch Processes > Payment > Payment Posting > Payment Posting Request
6) Post Withholding.
Navigation:  Suppliers > 1099/Global Withholding > Maintain > Post Withholdings > Withhold Transaction Post
7) Run 1099_RPT_PST process.
Navigation: Suppliers > 1099/Global Withholding > 1099 Reports > Withhold 1099 Report Job > 1099 Report Post / Report / Copy B


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.