Different Sorting Between All Activities And My Activities

(Doc ID 2374557.1)

Last updated on MARCH 16, 2018

Applies to:

Siebel CRM - Version 16.18 [IP2016] and later
Information in this document applies to any platform.

Symptoms

Different behavior is observed when sorting on Planned Start Date under Activities between All Activities and My Activities lists. 

SQL spooling shows that on All Activities list, the sorting on Planned Start runs a SQL with:
 ORDER BY
  T35.TODO_PLAN_START_DT DESC

But by sorting on the same on My Activities list it runs:
  ORDER BY
  T2.EMP_ID DESC, T2.ACT_TODO_PLNSTRTDT DESC



Why is the sorting not the same when it is the same applet (Activity List Applet With Navigation)?

How can we overcome this and have the sort to always use TODO_PLAN_START_DT DESC?

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