My Oracle Support Banner

Modification of User Key required (Doc ID 485456.1)

Last updated on JANUARY 07, 2020

Applies to:

Siebel Tools - Version 7.7.1 SIA [18306] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.1 [18306] Life Sci
Database: IBM DB2/UDB 8.1 FixPack 1S
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server

This document was previously published as Siebel SR 38-1517198291.

Symptoms

Hi

We have a business requirement to specify the educational speciality as well as the professional speciality of a Contact, this follows the structure of the external marketing data we are importing into Siebel.

For this we would like to use S_CON_BRD_SPEC but unfortunately the user key sequence of S_CON_BRD_SPEC is
1) CON_ID,
2) SPEC_ID and
3) CONFLICT_ID.

The result of this is that a Contact cannot have more than one relation to each Medical Speciality.

This would be solved by a TYPE column (that are present in many intersection tabels and that comes by default when creating a new one), but this needs to be in the user key and that we cannot change.

This is a critical requirement from the customer and it must be solved, somehow.

How can we achieve this? Is there a way to alter the user key?

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
 Message 1

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.