Issue With Opportunity Search in Production Environment (Doc ID 2580099.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Issue with Opportunity Search

Users have encountered a strange issue related to Opportunity advance search. When they search by adding only Business Unit as search criteria and sort the result by Amount in descending order we get lesser records in the search in sorted order.
However when we add an additional search criteria as Industry(Custom field) along with Business Unit and perform the same search by providing a value in Industry search field, we get more records in sorted order.

EXPECTED BEHAVIOR
-----------------------
The number of records should be same.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to App
2. Search Opty via advance search


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get required number of records.

Changes

Cause

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