Slow Performance during Pick Release Process.
Last updated on JULY 21, 2017
Applies to:
Oracle Warehouse Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
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
Steps
=====
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.
Changes
Recently applied the following patches
13994860 (31M) - Warehouse Management System
12595030 (13M) - Inventory Management
13850879 (20M) - Purchasing
11659334(18M)Payables
12359561(632K)Public Sector Applications
11930938(14M)Payables, 13827636(14M)Payables
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