Set Performance-Tuning for Opportunity Products Search

By setting a profile option, you can enable or disable the smart list in the Product list of values in the Products table in opportunities. The smart list is a pre-fetched list of products.

For performance reasons, Oracle recommends that if you have more than 5,000 products in the application, then you should prevent the entire smart list from being pre-loaded when a user clicks the pre-loaded list.

As a user types, the application searches against the product smart-list entries. If the user clicks the drop-down list then the application initializes the complete smart-list. To disable the preload of the smart list, set the profile option Preload Territory-Filtered Product List Enabled (ZBS_ENABLE_PRODUCTLOV_SMARTLIST) to No. By default, the profile option is set to yes.

Set the Profile Option

Here's how to set the Preload Territory-Filtered Product List Enabled profile option.

1. In the Setup and Maintenance work area, go to:

   • Offering: Sales

   • Functional Area: Sales Foundation

   • Task: Manage Administrator Profile Values

2. In the Manage Administrator Profile Values page, search for and select the profile option name, Preload Territory-Filtered Product List Enabled, or the code, ZBS_ENABLE_PRODUCTLOV_SMARTLIST.

3. Set the profile option to No to disable the preload of the smart list.

4. Save your changes.