My Oracle Support Banner

Sorting on a BC Field that is a Join to an External Table Does Not Work Consistently. Sort does not Work if Query Returns Larger Record Set. (Doc ID 1983063.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel CRM - Version [IP2013] and later
Information in this document applies to any platform.
Reviewed for relevance "2-SEP-2016".


On : [IP2013] version, Configuration - General

The Business Component was extended to show a Join Field from an External Table with its own Data Source.  The Business Component (BC) has a Join defined to the external table and Join Fields that use this Join.  The External Join BC fields were added to the BC applet.  This configuration worked to show the join fields, but there is an incorrect behavior for sorting on the External Table Join Fields.  If the query returns a small record set like less than 5 records, sorting on the External Table Join Field works.  If the query returns a larger record set that what can initially be displayed in the list applet, the Sort does not sort correctly.


 The change is a new configuration to show a BC field that is based on a join to an External Table.


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

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