Pay On Receipt Autoinvoice Fails to Create Invoices With Error "ORA-00001: unique constraint (AP.AP_INVOICES_INTERFACE_U1) violated" (Doc ID 1272563.1)

Last updated on AUGUST 14, 2017

Applies to:

Oracle Payables - Version 11.5.10.0 to 12.1.2 [Release 11.5 to 12.1]
Oracle Inventory Management - Version 11.5.10 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-Jul-2012***

Executable:POXPOIV - Pay On Receipt AutoInvoice
Report:APXIIMPT.RDF - Payables Open Interface Import


Symptoms

At the invoice creation stage, Pay On Receipt Autoinvoice program errors out with the following errors in its concurrent log:

POXPOIV module: Pay On Receipt AutoInvoice
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
create_receipt_invoices-110: ORA-00001: unique constraint 
(AP.AP_INVOICES_INTERFACE_U1) violated

Cause:        A SQL error has occurred in create_receipt_invoices.  
The SQL error is ORA-00001: unique constraint (AP.AP_INVOICES_INTERFACE_U1) violated.

Action:        Take note of both this error number and the actions you were 
trying to perform. Contact your system administrator for further assistance.
+---------------------------------------------------------------------------+

Steps to reproduce:

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