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 NOVEMBER 22, 2019
Applies to:Siebel CRM - Version 126.96.36.199 [IP2013] 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. ..."
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!