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

Last updated on JULY 11, 2022

Applies to:

Symptoms

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
(Seed_purge_tables)Invoices
(Inserting into ap_purge_invoice_list)Starting Seed_invoices
P_Purge_Name:Purge - Feb 27
P_Using_Accrual_Basis:Y
P_Using_Cash_Basis:N
g_activity_date:31-JAN-13
approx_rows: 0 pay_alone: A
ORA-00001: unique constraint (AP.AP_PURGE_INVOICE_LIST_U1) violated
Seed_invoices failed

Changes

Cause

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