Performance Issue In Material Workbench When Query By LPN

(Doc ID 1560295.1)

Last updated on AUGUST 21, 2016

Applies to:

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


Query WMS Control Board with LPN as input for Inbound and click on  Orgs (+) sign and the system takes more time.         

The Tkprof of the trace file shows the following expensive SQL


Expect the find results within seconds.

The issue can be reproduced at will with the following steps:
1. Using Warehouse Manager Responsibility,  Navigate: Inquiry > Material Workbench
2. On the material workbench, enter an From and To LPN as the same LPN and Click Find
3. Click the + sign next to organizations to expand the orgs.

Performance issue occurs, screen hangs for 10+ minutes before returning results


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