ECM: Argentina Localization - APVATPUR (VAT Purchase Report) Process Fails With The Error "ORA-00001: unique constraint (PS_TR_VATPUR_TMP) violated" (Doc ID 2087917.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

 APVATPUR (VAT Purchase Report) Process Fails

ERROR:
ORA-00001: unique constraint (SYSFIN.PS_TR_VATPUR_TMP) violated

STEPS:
1) Load a Bank Statement with multiple transactions that use the same bank statement code, VAT code for a given date
2) Run automatic reconciliation process and ensure external transactions are created for these bank statement lines
3) Run APVATPUR process (Setup Financials > Common Definitions > VAT and Intrastat> Value Added Tax > VAT Purchase Report)

SQR 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