EAP: Voucher Post (AP_PSTVCHR) Fails with the Error,"ORA-00001: unique constraint (PS_VCHR_TEMP3_LN7) violated at Step IU_PROCESSOR.U400.U400-010 (SQL)",when Posting a Regular Voucher Applied to a Inter Unit Prepaid Voucher (Doc ID 2065183.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

Voucher Post (AP_PSTVCHR) fails when posting a Regular Voucher that is applied to a Inter Unit Prepaid Voucher

ERROR:
Return: 805 - ORA-00001: unique constraint (PS_VCHR_TEMP3_LN7) violated
Process ABENDED at Step IU_PROCESSOR.U400.U400-010 (SQL) -- RC = 805

STEPS:
Ensure the Ledger Group has multiple translation and secondary ledgers and multibook is enabled for subsystem
1) Create a Inter Unit Prepaid Voucher
2) Post the Voucher
3) Pay the Prepaid voucher
4) Create a Regular Voucher for the same amount as Prepayment but with a different Invoice Date
5) Ensure that new market rate is entered for the date the regular voucher is created so that the new rate is used for the translation and secondary ledgers during voucher post
6) Apply Regular Voucher to Prepayment
7) Post the Regular Voucher

Process fails 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