Poor Performance On Locator LOV During Manual Drop When LPN Has Item With Large Number Of Lots (Doc ID 1965461.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

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.

Customer asked customer to perform the steps in Note 1315204.1, customer said the performance slightly improved

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

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

The trace file shows


FYI: Customer has performance issues 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

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