My Oracle Support Banner

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

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
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.