R12: AP: Payables Purge - ORA-00001: Unique Constraint (AP.AP_PURGE_INVOICE_LIST_U1) Violated Seed_invoices

(Doc ID 1634985.1)

Last updated on JUNE 27, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.


The AP Purge process fails with the following error:

Start of log messages from FND_FILE
(Updating table financials_purges)Starting Set_purge_status
(Check_no_purge_in_process)Starting Check_no_purge_in_process
Check_no_purge_in_processTHe AP_PURGE_INVOICE_LIST table contains records.
Please make sure no purges are running and clear
this table. Process terminating.
(Updating table financials_purges)Starting Set_purge_status
(Seed_purge_tables)Get Accounting Methods
(Get_Accounting_Method)Starting Get_Accounting_Method
(Get_Accounting_Method)End Get_Accounting_Method
(Seed_purge_tables)Starting Seed_purge_tables
(Inserting into ap_purge_invoice_list)Starting Seed_invoices
P_Purge_Name:Purge - Feb 27
approx_rows: 0 pay_alone: A
ORA-00001: unique constraint (AP.AP_PURGE_INVOICE_LIST_U1) violated
Seed_invoices failed


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