Multiple relationships between a contact and an asset using S_ASSET_CON
Last updated on JULY 05, 2017
Applies to:Siebel Tools - Version 220.127.116.11  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 18.104.22.168 
Database: Microsoft SQL Server 2000 SP3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: Microsoft Windows 2000 Advanced Server SP 2
This document was previously published as Siebel SR 38-1078383811.
***Checked for relevance on 07-Nov-2013***
***Checked for relevance on 08-SEP-2015***
On Account Screen -> Contact view, once a Contact is associated with the Account, same Contact couldn’t be added to the contact list applet. This is the expected behavior since S_PARTY_PER table has PARTY_ID and PERSON_ID as user key column. SBL-DAT-00357.
In vanilla S_ASSET_CON table, user key S_ASSET_CON_U1 has ASSET_ID, CONTACT_ID and RELATION_TYPE_CD user key columns. However on Asset Contact detail view (customized view), user could not associate the same contact that has different Type (maps to RELATION_TYPE_CD) to the same Asset. In that case, the error of “The selected record has already been added to the list” is raised. Could you please let me know why that happens? If we insert two records with same ASSET_ID, CONTACT_ID and different RELATION_TYPE_CD to the database directly, then on Asset Contact detail view, we could only see one record. Shouldn’t all these two records be displayed at UI?
I think this is a Siebel behavior issue instead of a configuration issue. Could you please do a test to check if you are seeing the same behavior using S_ASSET_CON table and create a custom Asset Contact detail view on Asset screen? Please expose Type on this view so that you could change the Type value once a Contact is associated.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms