LPN Unload Error ORA-01403: no data found

(Doc ID 2159689.1)

Last updated on JULY 19, 2017

Applies to:

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


On : 12.1.3 version, LPN Management

When performing LPN shipping, after loading the LPN and attempting to unload it, the user gets an error.

WMS_SHPTRX.LPN_UNLOAD: Error in lpn_unload : ORA-01403: no data found

The issue can be reproduced at will with the following steps:

IR - ISO Scenario
1. Ship LPN from Org. A to Org. B using internal sales order
2. Receive LPN in Org. B
3. Pick LPN in Org. B for external sales order
4. Load LPN to Dock using LPN Ship Menu in WMS Mobile
5. Unload LPN
Get the LPN Unload Error
Error in Inv. Log File: WMS_SHPTRX.LPN_UNLOAD: Error in lpn_unload : ORA-01403: no data found

It seems like the Unload LPN program checks the LPN in the delivery details and returned the record with shipped status in Org. A instead of Org. B




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