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

Last updated on JUNE 05, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
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

 

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

STEPS
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.

Changes

Applied Patch 16240055

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