Join from EBC to table in Siebel db AND external db?
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 7.7.2  to 8.1  [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 184.108.40.206
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”
An External Business Component (EBC) has been configured and an error is being generated.
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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms