My Oracle Support Banner

After Patch 16240055, Performance Issue In Warehouse Control Board When Querying Completed Tasks. (Doc ID 1602552.1)

Last updated on JULY 08, 2020

Applies to:

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


After Patch 16240055, suggested in Bug 16907813, users are now facing a severe performance issue with Warehouse Control board
when querying Outbound , Completed Tasks.

Users query the outbound, completed tasks for the shipment date in 1 day range. This was taking forever to query the completed tasks.
This runs for hours and finally users end up in closing the browser to kill the session.

Before the patch, this query used to fetch data in less than couple of minutes but now it is taking forever.

Gather schema stats was run and it still did not improve the performance.  All other programs are running fine except for the WMS Control board.

The following was the expensive SQL shown in the Trace file

Expensive SQL


Expect the query to be fast and return rows as expected .

1. Navigate to WMS Control board.
2. Query for Outbound, Completed and shipment date in 1 day range
3. Click Find. The screen freezes and never comes back.


Applied Patch 16240055


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

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