R12:AP: AP/PO Purge Summarization Routine Errors with "ORA-00001: unique constraint (AP.AP_HISTORY_INVOICES_U2) violated Invoice_Summary failed"
(Doc ID 2101318.1)
Last updated on FEBRUARY 26, 2021
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
The AP/PO Purge Summarization Routine ends in error. The following error shows in the log file:
The issue can be reproduced at will with the following steps:
1. Navigate to the Payables Manager
2. View -> Requests
3. Submit Purge Summarization (AP/PO Purge Summarization Routine)
Duplicate invoice numbers for same vendor is allowed in R12. But, the unique index does not recognize that.
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