My Oracle Support Banner

Error SBL-DAT-00452:Join in business component definition '%1' has source fields that come from tables '%2' and '%3' (Doc ID 2546337.1)

Last updated on APRIL 21, 2020

Applies to:

Siebel CRM - Version 8.1.1.1 [21211] and later
Information in this document applies to any platform.

Symptoms

The below error happens in two scenarios:

1. When inspecting a workspace (even without any changes) in versions above 19.x.

2. With a customized join (with multiple join specifications) in any version.  

SBL-DAT-00452:Join in business component definition '%1' has source fields that come from tables '%2' and '%3'

Steps to reproduce the error:

In Siebel 19.x and later, steps are as follows ( the example uses Contact BC, however the error can be seen with other BCs as well)

  1. Create a new workspace in Webtools or Siebel Tools
  2. Go to Contact BC  and add a comment on Field Work Phone
  3. In Callcenter application,open the Workspace and click Inspect button in Workspace Dashboard before delivery of workspace
  4.  Navigate to Contact screen and above error is observed

In any version (the example uses Household BC, however the error can be seen with other BCs as well)

  1. Open Web Tools or Siebel Tools
  2. Query for the "Household" Business Component
  3. Query for the Business Component's Join alias "Household Primary Position".



  4. Open the Join specification view for this join (there should be one join spec with destination column = PAR_ROW_ID and Source Field = Primary Position Id)
  5. Add a new Join spec where destination column equals "POSTN_TYPE_CD" and source field equals "Group Type Code"
  6. Commit the changes
  7. In the Call Center application navigate to the my household view. View load will fail with the error mentioned above.

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.