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 JULY 16, 2023

Applies to:

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.

Cause

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