EAP: Payment Posting Abends at AP_PSTCOMMON.CF_INH2.Step02 (SQL) With Unique Constraint Error on PS_AP_WTHDCF_TMP6

(Doc ID 2050134.1)

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.

Symptoms

Payment Posting Process AP_PSTPYMNT abends at step AP_PSTCOMMON.CF_INH2.Step02 (SQL) with the following error.

Error
------
ORA-00001: Unique Constraint (SYSADM.PS_AP_WTHDCF_TMP6).

Setup
-----
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.

Steps
------
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

 

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