My Oracle Support Banner

Saved Search Gives Error"The search cannot be executed because the table has pending changes that would be lost." In Indirect Direct Sales Managemet Page (Doc ID 2881534.1)

Last updated on AUGUST 23, 2022

Applies to:

Oracle Trade Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

After upgrade to R12.2.10 and saved search is giving the following error in Indirect Sales Management (IDSM) page.

ERROR
-----------------------
The search cannot be executed because the table has pending changes that would be lost.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Login to Applications
2. Go to Oracle Trade Management User Responsibility
3. Navigate to Channel Revenue Management >Indirect Sales Management
4. Query a saved search and get the result of saved search
5. Process Batch

 

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
References


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