External Business Component SQL is not Returning Correct Records. The EBC In Siebel Client Returns Less Number of Records Than the EBC SQL. (Doc ID 482364.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.7.2.1 SIA [18353] to 8.2.2 SIA[22320] [Release V7 to V8]
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.7.2.1 [18353] Fin Svcs
Database: Oracle 9.2.0.6
Application Server OS: Sun Solaris 5.8
Database Server OS: Sun Solaris 5.8
This document was previously published as Siebel SR 38-1959065221.
""Checked for Relevance on 04-Sep-2015""


Symptoms

We have an issue with the amount of data that is being displayed in an external business component. This is the issue:

I created an external business component based on an external table. I did follow all recommendations from Siebel Bookshelf and SupportWeb regarding the creation of the external tables and business component. Then I created a link between Contact and the external BC as a 1-to-many relationship using the field that is mapped to the Id System field in the table as the destination field in the link. I created an applet based on that EBC and included that applet in a view. This view should display, for a particular contact, all the records coming from the EBC that match the contact id.
The issue is that it shows only one record in the EBC even though we have several records for that particular contact. We tried different contacts and it is the same thing. I tried several possible solutions without success:

- Changing the link specification to point to the destination field Id instead of the field mapped to the column that is mapped to the system field id.
- Changing the column name of the column mapped to the system field id on the external table to be the same as the alias.

I ran out of options. Please help us!

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