My Oracle Support Banner

Why does Order Import fail with - ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row (Doc ID 848871.1)

Last updated on MARCH 22, 2024

Applies to:

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


When attempting to run Order Import concurrent program, the following error occurs:



The issue can be reproduced at will for a new sales order with following steps below

  1. Populate the data into Order Import interface tables.
  2. Go to Order Management Responsibility>Orders, Returns> Import Orders> Order Import Request
  3. Notice Order Import completed in Error
  4. Go to Orders, Returns> Import Orders>Corrections
  5. Query the Record by Order Source and Order Reference
  6. Select the Record and click on Errors and notice the error message as above




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

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