POI 850 ORA-00001: Unique Constraint (ont.oe_customer_info_iface_all_u1) Violated (Doc ID 2111790.1)

Last updated on FEBRUARY 29, 2016

Applies to:

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

Symptoms

When attempting to run POI for just one customer,
the following error occurs.

ERROR
 Program level ECE_INBOUND.INSERT_INTO_PROD_INTERFACE: Please check the log file, correct the problem, and try again.
 SQL error message ORA-00001: unique constraint (ONT.OE_CUSTOMER_INFO_IFACE_ALL_U1) violated.
  Insert failed for document(s).

STEPS TO REPRODUCE
1. ECommerce Gateway
2. Run POI for this customer
3. Go to "Staged Documents' > Click on the sub folder for POI > 'Inserted FAiled'
4. See there are over 600 failed orders for this customer


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