POI 850 ORA-00001: Unique Constraint (ont.oe_customer_info_iface_all_u1) Violated
(Doc ID 2111790.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to run POI for just one customer,
the following error occurs.
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
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