Performance Issue When Creating New Contact On SR Contact Pick Applet: Repeated SELECT COUNT (*) SQL Statements (Doc ID 1901843.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Financial Services CRM - Version 8.1.1.11 SIA [23030] and later
Information in this document applies to any platform.

Symptoms

There is a performance issue on the SR Contact Pick Applet when creating a new Contact.

The issue occurs in Open UI with both dedicated and thin clients.
Too, the performance issue occurs in an environment with millions of Contacts.  The same performance degradation is not observed in an environment with less than 10,000 Contacts.


STEPS:
1.  Navigate to the Service Request view.
2.  Drill down on a Service Request.
3.  Create a new Service Request by using the New button in the Form Applet.
4.  Invoke the pick applet on the Contact Last Name Field.

Result: This will display the SR Contact Pick Applet.

5.  Click the New button in the Pick Applet to create a New Contact.

Result: This request takes a long time for the form applet to open in order to enter the new contact details.

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