EAP Brazil Localization: Payment Posting abends at AP_PSTPYMNT BB000 BB000-2C, unique constraint error (Doc ID 1994626.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Payables Brazil - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

When running Payment Posting, process abends at Step AP_PSTPYMNT.BB000.BB000-2C with an error.

ERROR
-- 14.15.29 Process 13449 ABENDED at Step AP_PSTPYMNT.BB000.BB000-2C (Action SQL) -- RC = 805
ROLLBACK
/
-- 14.15.29 SQL Error: ORA-00001: unique constraint (SYSADM.PS_VCHR_TEMP_LN4) violated

STEPS
1.  Withholding Entity = RF-S and ISSPE
2.  Vendor = BRAP1714
3.  Create a Voucher with 2 Withholdings (RF-S and ISSPE)
4.  Pay the Vouchers (Main Vendor and Withholdings, RF-S and ISSPE)
5.  Run Payment Posting
6.  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