identical rows in AP_HISTORY_INVOICES_ALL
I am running an Archive and Purge operation on AP, which involves Conurrrent Request APXPGSUM. That one is erroring out with :
ORA-00001: unique constraint (AP.AP_HISTORY_INVOICES_U2) violated
Invoice_Summary failed.
MOS tells me that ID 266065.1 could be the cause of this issue. It states that you must check to find invoices which are identical. These should be removed.
Now, not much more technical detail is given, so my obvious question is : how do I detect "identical invoices". It doesn't detail on which part they would be identical.
I'm not sure this is a technical or a functional question.