My Oracle Support Banner

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

Last updated on AUGUST 02, 2018

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.