My Oracle Support Banner

R12:AP: Open Interface Invoices Import Program Error ORA-00001: Unique Constraint (AP.SYS_AP_INVOICES_U4) Violated (Doc ID 2981895.1)

Last updated on OCTOBER 27, 2023

Applies to:

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

Symptoms

Invoice stuck in interface with no rejections in the AP_INTERFACE_REJECTIONS table.

Error in the FND Log:

ORA-00001: unique constraint (AP.SYS_AP_INVOICES_U4) violated



 

Steps to reproduce:

1. Payables Manager Responsibility > Other > Requests > Run > Single Request - Input Open Interface Invoice Import

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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