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

Last updated on AUGUST 01, 2014

Applies to:

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

Symptoms

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

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)

STEPS
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

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