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.

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


Cause

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