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.
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
Expect this to be less than a minute
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms