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:
Oracle Receivables - Version 11.5.10.2 and laterInformation in this document applies to any platform.
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
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 |
Cause |
Solution |