My Oracle Support Banner

SBL-DAT-60277 - The Query Could Not Be Run Because It Is Too Big During Modification Order (Doc ID 2540966.1)

Last updated on MAY 08, 2023

Applies to:

Siebel CRM - Version 8.1.1.11.16 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.16 [IP2013] version, Order Management

When trying to create modification quote after selecting 528 assets an error is observed.

In positive scenario ( modification of 2 assets ), in step [Edit Asset Selections] of WF : TMO Annex Order Process, siebel run 3 queries through [Asset Mgmt - Asset Header] BC and in 3rd query it has got in condition lists of edited assets id's.
In negative scenario, first two queries looks same, but in third query, siebel run query without any asset id's.

ERROR
-----------------------
SBL-DAT-60277 The Query Could Not Be Run Because It Is Too Big during modification quote.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Account > Installed Assets
2. Select more than 500 assets

3. Click on Modify button

Changes

 

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
Changes
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.