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 OCTOBER 07, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
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

Example:

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 which swaps the value for first attribute with 3rd attribute.
Error message shows Attribute1=GHI, Attribute2=DEF, Attribute3=ABC.

EXPECTED BEHAVIOR
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.


STEPS
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.

Changes

 

Cause

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 hundreds of Community platforms