Copying an LOV may result in error "The same values for 'Type, Value, Language, Sub Type' already exist."
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 7.5.3  to 8.1  [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"
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'.
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