My Oracle Support Banner

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 FEBRUARY 04, 2019

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

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.