My Oracle Support Banner

CRM: Resolving performance issues by using Lookup Exclusion Table.. (Doc ID 619159.1)

Last updated on APRIL 16, 2024

Applies to:

PeopleSoft Enterprise CRM Advanced Configurator - Version 8.8 and later
PeopleSoft Enterprise CRM for Financial Service - Version 8.8 and later
PeopleSoft Enterprise CRM for Energy - Version 8.8 and later
PeopleSoft Enterprise CRM for High Technology - Version 8.8 and later
PeopleSoft Enterprise CRM for Government - Version 8.4 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 200746517



Symptoms


When clicking on the lookup button next to any field.. an automatic execution to the server is made which executes unqualified SQL to the database and fetches a lot of records.... resulting in a performance issue.

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

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