Warehouse Control Board "Completed" Tasks Performance Issue (Doc ID 1601590.1)

Last updated on JUNE 02, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
We are testing for our R12 upgrade. At Warehouse Control Board (R12.1.3), I was searching the outbound tasks assigned to me just for one day. It took around 13 minutes to return the searching result, even through there are only a few records. And it took longer and longer when I tried for a few times.

So far , It looks like that the performance is caused by the " Completed" status. I searched for all other Status together except ' Completed", the result came out fast. And I also tried for different Source and it seems that the " Completed" status is the issue.

RUP7 patch 16812342:R12.WMS.B looks like it can resolve the issue, the we cannot afford to apply a RUP patch at this time. Please get us a one-off patch.

EXPECTED BEHAVIOR
-----------------------
Expect that the query should take seconds, not 13 minutes or longer.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Warehouse Control Board
2. Search for Completed tasks,
3. Note the time it takes for the query to return the results.

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