Maximum Number of Queried Records Exceeded Error When More than 10 New Products are Added - FRM-41835 (Doc ID 752510.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

On 7.1.1 in Production:
When attempting to more than 10 new items to the New Product Form (for later inclusion into
Demantra then the following error occurs)

ERROR
FRM-41835 (Receive FRM-41385 Maximum Number of Queried Records Exceeded)

STEPS
The issue can be reproduced at will with the following steps:
1. Demand Management System Administrator Demand Management>Setup>New Products List
2. Add more than 10 new products and receive the error

BUSINESS IMPACT
The issue has the following business impact:
The records are actually saved successfully to the MSD_DEM_NEW_ITEMS table but the error message
is misleading and the end user, unless they have SQL access to view the MSD_DEM_NEW_ITEMS table, will think not all the products were saved.

.

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