My Oracle Support Banner

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 to [Release 11.5.10]
Information in this document applies to any platform.


-- Problem Statement:
On 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

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