My Oracle Support Banner

ECO Gives Jumbled Error Message EGO_EF_LONG_UK_VIOLATION Or EGO_EF_UKn_VIOLATION During Change Order Creation (Doc ID 2111488.1)

Last updated on APRIL 03, 2018

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.


During UDA update through ECO, the error thrown is jumbled/swapped, when user is trying to add a row for an attribute group which already exists in the system


Attribute1=ABC, Attribute2=DEF, Attribute3=GHI and user is trying to add same value again.
You see error message (EGO_EF_LONG_UK_VIOLATION Or EGO_EF_UKn_VIOLATION) about same data in the system, but message swaps the value for 1st attribute with 3rd attribute.
Error message shows Attribute1=GHI, Attribute2=DEF, Attribute3=ABC.

Expect the error message to be correct without swap of attribute values.

NOTE: this is a valid error. Check your data and any Rules you have set up; the system should not allow you to enter duplicate values.

The issue can be reproduced at will with the following steps:
1. Setup UDA with attribute combinations having 3 or more attributes with unique keys
2. Setup a business rule for above UDA for some combinations to be not allowed
3. Try to create a Change Order with Invalid combination or duplicated combination.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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