Field Name is Missing in the message "SBL-DAT-00382: The same values for '(?)' ..." when unique S_CON_ADDR_U1 index is violated. (Doc ID 2019540.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Symptoms

FUNCTIONALITY:
-----------------------
Custom Server side code code (Siebel eScript) which is attempting to add duplicate recorded into the S_CON_ADDR table (Account or Contact to Address association table)
 and so violating unique standard table user key index: "SIEBEL.S_CON_ADDR_U1"

ISSUE:
--------
The Error message about violation unique index does not include the filed name of included in the user key:
"... SBL-DAT-00382: The same values for '<?>' already exist.If you would like to enter a new record, please ensure that the field values are unique. "

EXPECTED:
--------------
The name of the columns which are part of in the table user key(such as "Stard Date" in the "S_CON_ADDR_U1" user key) is mentioned:
"...
"... SBL-DAT-00382: The same values for 'Start Date' already exist.If you would like to enter a new record, please ensure that the field values are unique. ..."

 

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