ECM: Argentina Localization - APVATPUR (VAT Purchase Report) Process Fails With The Error "ORA-00001: unique constraint (PS_TR_VATPUR_TMP) violated"
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.
APVATPUR (VAT Purchase Report) Process Fails
ORA-00001: unique constraint (SYSFIN.PS_TR_VATPUR_TMP) violated
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
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