Performance Issues When Querying Outbound, Completed Tasks In The Warehouse Control Board Using Creation Date (Doc ID 1922583.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Warehouse Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
After applying WMS RUP 9 (patch 18618946 ) , users are now facing a severe performance issue with Warehouse Control board when querying Outbound , Completed Tasks.
Users experience the perfomance issue when querying for completed outbound tasks within a 1-day creation date parameter.

 Prior to applying the WMS RUP 9, this query would take less than a minute to present results.
Now this query runs for hours and eventually users end up in closing the browser to kill the session.

Now the query takes about an Hour to complete.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply RUP 9
2. Navigate to the WMS Control board and query for completed outbound tasks within a 1-day creation date
3. Notice the performance issue

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms