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.
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 220.127.116.11.4 [IP2013] and later
Information in this document applies to any platform.
Reviewed for relevance "2-SEP-2016".
On : 18.104.22.168.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.
The change is a new configuration to show a BC field that is based on a join to an External Table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms