My Oracle Support Banner

Interface Trip Stop Fails With ORA-00001: "unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row" (Doc ID 2716360.1)

Last updated on OCTOBER 02, 2020

Applies to:

Oracle Shipping Execution - Version 12.2 and later
Oracle Order Management - Version 12.2 and later
Information in this document applies to any platform.
ORA-00001
"unique constraint"
OE_ORDER_LINES_U1
"Package oe_line_util"
"Procedure Insert_Row"

Symptoms

When attempting to run the Interface Trip Stop, the following error occurs:

ERROR
Calling program unit OE_MSG_PUB.GET
ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row
Error msg: ORA-00001: unique constraint (ONT.OE_ORDER_LINES_U1) violated in Package oe_line_util Procedure Insert_Row


STEPS
The issue can be reproduced at will with the following steps:
1) Order Management Super User Responsibility
2) Shipping
3) Interfaces




NOTES
Has already applied <Patch 14350185>:R12.ONT.B

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.