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 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
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
Symptoms |
Changes |
Cause |
Solution |
References |