How to Use Close Period Filter With Previous and Current Quater in Advanced Search on Opportunity (Doc ID 2458045.1)

Last updated on DECEMBER 22, 2020

Applies to:

Symptoms

On : 11.13.18.05.0 version, Opportunities

ACTUAL BEHAVIOR
---------------
When searching for an Opportunity in Advanced Search and passing Close Period filter and fill in the value Previous and Current Quarter, it doesn't return any results.

EXPECTED BEHAVIOR
-----------------------
The Opportunity should show in the Advanced Search when using this Search filter with value: Close Period to Previous and Current Quarter.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigator > Opportunity > Advanced Search
2. Search for Opportunity Number 
3. Set the Close Period to Previous and Current Quarter > Search > the Opportunity is not showing up
4. When changing the Close Period filter to All, the Opportunity is returned by the Search.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use Search properly.

Cause

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