Field Name is Missing in the message "SBL-DAT-00382: The same values for '(?)' ..." when unique S_CON_ADDR_U1 index is violated.
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 220.127.116.11  and later
Information in this document applies to any platform.
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"
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. "
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. ..."
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