R12: Create Intercompany AP Invoices Concurrent Program (INCIAP) Fails With Error "ORA-00001: unique constraint (AP.AP_INVOICES_INTERFACE_U1) violated"

(Doc ID 1147788.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle E-Business Tax - Version 12.0.0 and later
Oracle Inventory Management - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 9-May-2013
Executable:INCIAP - Create Intercompany AP Invoices


Symptoms

On release 12.0.6:

Create Intercompany AP Invoices concurrent program (INCIAP) will fail with the following error in the request log.

SQL Error in inapcih(). APP-FND-01564: ORACLE error 1 in inapcih()
Cause: inapcih() failed due to ORA-00001: unique constraint (AP.AP_INVOICES_INTERFACE_U1) violated

The issue has been reported with the case of Zero (exempted) tax rate.

Steps to Reproduce:
Launch the Create Intercompany AP Invoices concurrent program

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