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
Million Knowledge Articles and hundreds of Community platforms