Join from EBC to table in Siebel db AND external db? (Doc ID 543647.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.7.2 [18325] to 8.1 [21039] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: IBM AIX 5L 5.2
""Checked for Relevance on 13-MAY-2016""

This document was previously published as Siebel SR 38-1532354651.


”Checked for Relevance on 04-Dec-2014”

Symptoms

An External Business Component (EBC) has been configured and an error is being generated.

Details
------------
Using the view Household-Policies based on the BC's Household and VGZ EBC FINS Household Policies - Read Only.

BC Household is linked to a the table S_PARTY which resides in the Siebel Database. The External Business Component VGZ EBC FINS Household Policies - Read Only is linked to the table EX_CSA_0000008 (copy of S_ASSET) which resides in the external database.

From VGZ EBC FINS Household Policies - Read Only, we join in two fields from the tables below:
Column GROUP_OU_ID from S_GROUP_CONTACT which resides in the Siebel database (this is a vanilla join)
Column X_CSA_0000011_0005 from EX_CSA_0000011 (copy of S_ASSET_CON) which resides in the external database

The join from EX_CSA_0000011 works fine but the join from S_GROUP_CONTACT gives us trouble.

Application is looking for the S_GROUP_CONTACT in the external database instead of the Siebel database. This table is not present in the external database, so the application will generate a SQL-error.

Is it possible to join in fields from a Siebel table from a BC that is based on an External Table?

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