My Oracle Support Banner

Error Marking Quote As Active [Error: cafsl.OracleQuoteTrigger: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 200000 rows).] (Doc ID 2689613.1)

Last updated on JUNE 28, 2022

Applies to:

Oracle BigMachines CPQ Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When attempting to mark a quote as active,
the following error occurs.

Error:
cafsl.OracleQuoteTrigger: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 200000 rows). Consider an indexed filter or contact salesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times) Class.cafsl.OracleQuoteLineItemTriggerHelper.validateOqlis: line 163, column 1 Class.cafsl.OracleQuoteLineItemTriggerHelper.updateOlis: line 18, column 1 Class.cafsl.OracleQuoteTriggerHelper.syncOlis: line 64, column 1 Trigger.cafsl.OracleQuoteTrigger: line 60, column 1

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
References


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