My Oracle Support Banner

Personalization query causing performance issues (Doc ID 780786.1)

Last updated on NOVEMBER 22, 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


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


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.

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)


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.