My Oracle Support Banner

Personalization query causing performance issues (Doc ID 780786.1)

Last updated on APRIL 21, 2019

Applies to:

Siebel CRM - Version 7.7.1 SIA [18306] to 8.2.2 SIA[22320] [Release V7 to V8]
Information in this document applies to any platform.
Checked for relevance on June, 03, 2013

Symptoms


Customer is having the following issue of performance impact on load of home page when they are using personalization expression.

STEPS TO REPRODUCE:
-----------------------------

1. Define a personalization expression on the applet of a home page view such as follows:

Conditional Expression for the Applet:

BCHasRows ("Employee","Employee","[Login Name] = '" + GetProfileAttr("Login Name") + "' AND EXISTS([Responsibility] Like 'MRM Finance*')", "")

2. Try to load the home page after logging into the application.

3. It will take several minutes to load the home page itself.

ACTUAL BEHAVIOR:
-----------------------
Home page is taking lot of time to get loaded when using a personalization condition on an applet to view that applet depending on the logged in users responsibility ( not necessarily primary responsibility)

EXPECTED BEHAVIOR:
--------------------------

Whatever the personalization expression may be and whether it fails or succeed but the home page should not take much time to get loaded after logged into the application.

Cause

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
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.