Slow Performance during Pick Release Process.

(Doc ID 1497804.1)

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.

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