My Oracle Support Banner

Slow Performance during Pick Release Process. (Doc ID 1497804.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

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


On Rel 12.1.3, In Oracle Warehouse management, Users noticed Performance issue while pick releasing a set of orders. Pick release was taking a long time when the picking rule is having a restriction on
"Stock Onhand -> Material Status"

THe following SQL seem to be the time consuming SQL as per the SQL trace

1. Create a picking rule with restriction of "Stock Onhand" as object and "Material Status" as parameter.                         
2. Assign the rule in workbench.                                   
3. Create Onhand to satisfy/unsatisfy the Rule restrictions       
4. Create a SO and pick release it. Notice the performance issue.


 Recently applied the following patches

13994860 (31M) - Warehouse Management System
12595030 (13M) - Inventory Management
13850879 (20M) - Purchasing
12359561(632K)Public Sector Applications
11930938(14M)Payables, 13827636(14M)Payables


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.