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 MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.11.4 [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.

Changes

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

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