My Oracle Support Banner

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:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.

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

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.