My Oracle Support Banner

Poor Performance On Locator LOV During Manual Drop When LPN Has Item With Large Number Of Lots (Doc ID 1965461.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
In Oracle Warehouse Management, the Locator LOV on the Manual  Drop page was having poor performance and taking a lot of time to process the input in case of transaction for an LPN having  item which had large number of lots in onhand.

Performance issue was noticed during the following  transactions for Item has huge number of Lot numbers packed in LPN.

Mobile Subinventory Transfer Enter LPN. Validation on LPN field. = > Takes 15 secs.
Mobile Subinventory Transfer Enter LPN, to sub. Validation on to sub field. = > Takes 15 secs.
Mobile Subinventory Transfer Enter LPN, to sub, to locator. Validation on to loc field . = > Takes 20 secs.

It takes 12 seconds from after the subinventory to when it is validated and the cursor moves to the next field.

The trace file shows:


Note: Performance issues also exist on several other transactions like the following:

1) Picking from loose on Pick Load UI
2) Lot Number field exit on Unpack and Split UI
3) LPN Inquiry - Pressing LPN contents button
4) Locator LOV on Manual Drop/Move Any LPN
5) Overall performance was poor on Move Any LPN

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into Mobile
2. Performance subinventory transfer
3. Notice performance issue.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.