EAP Argentina Localization: VAT Purchase Report Ends in Error When a Voucher is Un-posted Twice in Different Periods (Doc ID 2088665.1)

Last updated on DECEMBER 14, 2015

Applies to:

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


The VAT(Value Added Tax) Purchase report ends in ERROR when a voucher is un-posted twice in different periods.

SQL Error number ORA-00001: unique constraint occurred.



1:Enter a voucher.
2:Post the voucher.
3:Voucher Accounting entries.
4:Unposting the voucher.  Set accounting date at 29/10 and  the unposting date at 28/10
5:Run the VAT purchase report. The voucher is not shown.  It seems fine due to the voucher is currently unposted (posted-unposted)
6:Run the VAT sales report. The unposted voucher  is not shown. It is fine.
7:Post the voucher again (with accounting date at 29/10/2015)
8:Run the VAT purchase report. The voucher is shown in October.  It is fine, due to the voucher has been posted again.
9:Run the VAT sales report. The unposted voucher  is not shown.  It is OK.
10:Unpost  the voucher once more and set the new accounting date and the unposting date in the following month.Then Accounting date is set at 11/11
11:Post the voucher again.
12:Run the VAT purchase report for 10/2015 and it ends in ERROR.


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