Join in business component throwing error SBL-DAT-00452 (Doc ID 519200.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.3 SIA [16157] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] Life Sci
Database: Oracle 8.1.7.4
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


Symptoms

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)"

Cause

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