My Oracle Support Banner

Splitting Serial Numbers Of Different Lengths Causes Data Corruption (Doc ID 3024509.1)

Last updated on JUNE 29, 2024

Applies to:

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

Symptoms

 IN WMS Mobile>When Splitting LPN's having Serial Numbers of different Lengths via LPN Transactions>>Split function, it causes data corruption on at time of LPN Delivery.

The issue can be reproduced at will with the following steps:
1) Pick release an order using the Release Pick Waves form.
2) Using the Paper Based Pick functionality in Mobile Client, Pick the entire quantity into an LPN (Example Quantity 20).
3) This Pick included serial number of different lengths. For example.  Some Serials are 7 alpha-numeric characters, others are 10 characters
4) Using the Drop Loaded LPNs Functionality via Mobile to drop the picked LPN into the staging location.
   **NO issue to this point**
5) Using the Split Functionality in Mobile using Navigation: Warehousing>>LPN Transactions>>Split >>Split (Quantity example 10) from the picked LPN into a generated LPN.
   The delivery is now corrupted.  When attempting to transact LPN that was split, the following error occurs: 'APP-INV-05577: You are trying t use one or more serial numbers that are not available for use in this transaction.'
 

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.