ORA-00001: Unique Constraint (Ont.Oe_order_headers_u2) Violated In Package
(Doc ID 798256.1)
Last updated on DECEMBER 09, 2022
Applies to:Oracle Order Management - Version 126.96.36.199 to 188.8.131.52 [Release 11.5.10]
Information in this document applies to any platform.
Symptoms-- Problem Statement:
On 184.108.40.206 in Production:
When attempting to enter a new Quote,
the following error occurs:
ORA-00001: unique constraint (ONT.OE_ORDER_HEADERS_U2) violated
in Package OE_Header_Util Procedure Insert_Row.
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. using Order Management responsibility navigate to >Negotiation>Quotes
2. enter customer, order types
3. save quote
-- observe above mentioned error --
-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot create quotation to be filed with customer so ultimately unable to create and book sales order.
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