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 APRIL 22, 2024

Applies to:

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






Symptoms

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

 ERROR

 STEPS

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

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
References

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