My Oracle Support Banner

EAP: Update Withholding abending at Step AP_WTHD_UPDT.UpdLines.Step01 (SQL) -- RC = 805 (Doc ID 1294201.1)

Last updated on FEBRUARY 01, 2023

Applies to:

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


Update Withholding is abending at Step AP_WTHD_UPDT.UpdLines.Step01 with an error.

Cannot insert duplicate key row in object 'dbo.PS_WTHD_UPDT' with unique index 'PS_WTHD_UPDT'.

Process 1778127 ABENDED at Step AP_WTHD_UPDT.UpdLines.Step01 (SQL) -- RC = 805 (108,524)

1.  Create a Voucher that has 1 line setup for Withholding and another line that is non-Withholding
2.  Pay the Voucher
3.  Run Payment Posting
4.  Run Post Withholding
5.  Through Update Voucher Line Withholding, display the Voucher created in Step 1
6.  Make the non-Withholding line Withholding
7.  Run Update Withholding
8.  Process will abend with the above error


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.