Join in business component throwing error SBL-DAT-00452
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 7.5.3 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3  Life Sci
Database: Oracle 126.96.36.199
Application Server OS: Microsoft Windows 2000 Server SP 3
Reviewed for relevance "12-AUG-2013".
Database Server OS: IBM AIX 4.3.3
This document was previously published as Siebel SR 38-1521682251.
Checked for Relevance on 30-08-2010
The requirement is to display in the Contact List Applet the Primary Position Status.
I created a join Primary Position join to S_POSTN_CON table in BC Contact. In the specification, I enter; Dest: CON_ID --> Source: ID and Dest: POSTN_ID --> source: Primary Position ID.
I created a field called "Primary Position Status" base on my new join to get the field "Status".
Add the field to the Contact List Applet.
I get on execution the following message:
"Join in business component definition 'Contact' has source fields that come from tables 'S_PARTY' and 'S_CONTACT'(SBL-DAT-00452)"
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