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.

Symptoms


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
)


Changes

 Duplicate invoice numbers for same vendor is allowed in R12.  But, the unique index does not recognize that. 

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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