My Oracle Support Banner

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:

ORA-00001: unique constraint (AP.AP_HISTORY_INVOICES_U2) violated Invoice_Summary failed

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.