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.
Voucher Post (AP_PSTVCHR) fails when posting a Regular Voucher that is applied to a Inter Unit Prepaid Voucher
Return: 805 - ORA-00001: unique constraint (PS_VCHR_TEMP3_LN7) violated
Process ABENDED at Step IU_PROCESSOR.U400.U400-010 (SQL) -- RC = 805
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
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