E1: GRID: Enhancement Bug For Advanced Query-Request Option To Add Business Days Only (Doc ID 2798485.1)

Last updated on SEPTEMBER 21, 2021

Applies to:

Symptoms

Requesting to add an option in Query Manager to use Business Days and not All days when querying Today + and Today - in Set Special Value.

Example:

Would like to check orders with a ship date of less that 2 days.

1. Fast Path to P4210

2. Select Manage Queries

3. Then select Actual Ship (QBE) under Conditions.

   For this scenario - It is a Tuesday and when  "Today - 4 days" is used, the result will be Friday of the previous week.

Would like option to query Business Days, like a Workday calendar. So if the Business Days were Monday -Friday, the query would show Wednesday of the previous week instead of Friday.

The current functionality does not give an option to use Business Days only in the query.

Changes

 N/A

Cause

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