Order Booking Error: ORA-00001: unique constraint (Ont.Oe_order_lines_u1) violated in package OE_LINE_UTIL Procedure Insert (Doc ID 1328594.1)

Last updated on MAY 17, 2021

Applies to:

Symptoms

When you attempt to Book an Order for an International Ship To and Bill To address, you get the following error:
ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in package oe_line_util procedure insert_row

Below describes the setup you created:

You have a business requirement to make a call to Vertex for all sales orders whether it is national or international sales order. To do this you have setup System Options > Tax defaults to LOC without setting up any hierarchy. You do not intend to setup tax codes at the customer site level. For International Ship To addresses, you set up a dummy Tax Area ID for International Ship To addresses.  You expect this tax setup to work for the following scenarios:

1. US Ship To and Bill To addresses
2. US Ship To and International Bill To addresses
3. International Ship To and US Bill To addresses
4. International Ship To and International Bill To addresses

The tax calculation works as expected for the first 3 scenarios but not the last one, where it raises the error:
ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in package oe_line_util procedure insert_row 

Cause

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