Users Get "Please wait" Message During LPN Ship In Mobile

(Doc ID 2172668.1)

Last updated on AUGUST 16, 2016

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
When using LPN Ship transaction with multiple shipments, then Ship Confirm takes a few minutes.

This is happening after upgrading to 12.1.3. Gather stats has been run. However, any time there is a large shipment involving multiple items/LPNs, the 'Please Wait' message appears on the scanner.

The SQL trace file for the performance issue, shows the following expensive SQL


EXPECTED BEHAVIOR
-----------------------
Expect this to be less than a minute

STEPS
--------
1. Login into Mobile Telnet/GUI
2. Navigate: Outbound > Shipping > LPN Ship
3. Enter the needed information and click on Ship All
4. Notice the "Please wait" message.

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