Slow Performance during Pick Release Process.
Last updated on JULY 21, 2017
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
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