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 laterInformation 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
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 |
Cause |
Solution |