Copying an LOV may result in error "The same values for 'Type, Value, Language, Sub Type' already exist."

(Doc ID 523408.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 7.5.3 [100] to 8.1 [21039] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
This document was previously published as Siebel SR 38-1855198311.
""Checked for Relevance on 03-Sep-2013""
"Checked for Relevance on 02-Sep-2015"

Symptoms

SBL-DAT-00382

Copy an existing LOV record and change the display name. Attempt to save the new record and get error:


"The same values for 'Type, Value, Language, Sub Type' already exist."

 

Check your Siebel server object manager log file you should find a "DBC" error like this to tell you exactly which user key is being violated, i.e.:

DBCLog DBCLogError [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'S_LST_OF_VAL' with unique index 'S_LST_OF_VAL_U2'.

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