Personalization query causing performance issues (Doc ID 780786.1)

Last updated on MARCH 02, 2017

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

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