Modification of User Key required
(Doc ID 485456.1)
Last updated on JANUARY 07, 2020
Applies to:Siebel Tools - Version 7.7.1 SIA  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.1  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.
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
2) SPEC_ID and
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?
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