Performance Issue With Calendar GanttChart OUI Applet (Doc ID 2093550.1)

Last updated on JUNE 12, 2016

Applies to:

Siebel Finance Service - Version 8.1.1.14.9 [IP2014] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.14.9 [IP2014] version, System Admin

ACTUAL BEHAVIOR
---------------


We have recently upgraded to IP2014 PS9 from IP2014 PS16. During our SVP runs it was highlighted that one of the queries around the calendar gantt chart (eCalendar Detail View - Calendar GanttChart OUI Applet) is firing many times. Roughly 3 million times during a steady state of 2 hours. This is causing resource utilisation. From our investigation we believe that the query runs for each activity present in the time frame for each user added to the ganttchart.

Example:
'Assigned to' -> User A has 7 activities. The query fire 7 times
Now Add user B in 'Assigned to' having 7 activities.
The ganttchart refreshes and the query is fired for user B 7 times and again for user A 7 times.
Thus making the total execution count to 7+7+7 = 21 like an arithmetic progression.

Please find the sql and logs from dedicated attached.


EXPECTED BEHAVIOR
-----------------------
SQL should not trigger more times


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. 'Assigned to' -> User A has 7 activities. The query fire 7 times
2. Now Add user B in 'Assigned to' having 7 activities.
3. The ganttchart refreshes and the query is fired for user B 7 times and again for user A 7 times.
4. Thus making the total execution count to 7+7+7 = 21 like an arithmetic progression.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot .

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