EAP: Payment Posting Abends at AP_PSTCOMMON.CF_INH2.Step02 (SQL) With Unique Constraint Error on PS_AP_WTHDCF_TMP6
Last updated on MARCH 18, 2016
Applies to:PeopleSoft Enterprise FIN Payables - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
Payment Posting Process AP_PSTPYMNT abends at step AP_PSTCOMMON.CF_INH2.Step02 (SQL) with the following error.
ORA-00001: Unique Constraint (SYSADM.PS_AP_WTHDCF_TMP6).
1. Setup two Withholding Rules with 10% and 2% respectively.
2. Setup Rounding Option to 'TDS' on two Withholding Entities.
3. Associate these Rules and Entities to the Vendor.
1. Create a Voucher for the above Vendor for an amount of 136 INR.
2. Post the Voucher.
3. Withholding schedule is created for 10 INR.
4. Make the Payment using Pay Cycle.
5. Post the Payment and the process fails
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