Bad Performance Whenever LPN Has Multiple LOTS (Doc ID 1577594.1)

Last updated on OCTOBER 14, 2015

Applies to:

Oracle Warehouse Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In Oracle Warehouse Management ,  doing subinventory transfer with License Plate Number (LPN)  having multiple Lots, the performance is bad.
Higher number of LPN's with Lots have slower performance.

The expensive SQL that was identified using the Trace is

 

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