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 22.214.171.124 SIA  to 8.2.2 SIA [Release V7 to V8]
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 126.96.36.199  Fin Svcs
Database: Oracle 188.8.131.52
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""
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!
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|