My Oracle Support Banner

Users Are Unable To Reuse Serial Numbers Once Shipped (Doc ID 2508231.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 9.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.0.0 version, Core Product Functionality

ACTUAL BEHAVIOR
---------------
Company Parameter Serial Number Tracking Level = 1 and Item is setup with Serial Validation = Required, do not validate
Once a serial number is shipped users can reuse it for another order.

EXPECTED BEHAVIOR
-----------------------
Expected that WMS should prevent a serial number from being reused, even if it is shipped.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Company Parameter Serial Number Tracking Level = 1
2. Setup a new Item ITMSER0001 with Serial Validation = Required, do not validate
3. Created an IB Shipment for Item ITMSER0001 for Qty = 3 and received the entire Shipment into LPN IBLPN0015
4. Putaway the LPN IBLPN0015. the LPN is now located.
5. Created a new Order ORDERTEST100 for item ITMSER0001 for Qty = 3
6. Ran wave and Tasks got Generated. Execute the TASK. OBLPN = OBLPNTEST100, OBLPN is now in Picked Status
7. Use the Repack OBLPN screen to Pack the OBLPNTEST100 into another OBLPN OBLPNTEST101
System now prompts to Serials to be entered. Enter Serial - XSER000001, XSER000002, XSER000003

8. Once the Pack is completed. Noticed that the LPN OBLPNTEST101 is packed status.
9. Perform the OBLoad and complete the shipping. Now the XSER000001, XSER000002, XSER000003 are in SHIPPED Status.

10. Created a new Order ORDERTEST200 for item ITMSER0001 for Qty = 3
10. Ran wave again and Tasks got Generated. Execute the TASK. OBLPN = OBLPNTEST200,. OBLPN is now in Picked Status
7. Use the Repack OBLPN screen to Pack the OBLPNTEST200 into another OBLPN OBLPNTEST201
System now prompts to Serials to be entered. Enter Serial - XSER000001, XSER000002, XSER000003
Users are able to enter the Serials and there are no validation or warning mesages shown

8. Once the Pack is completed. Noticed that the LPN OBLPNTEST201 is packed status.
9. Perform the OBLoad and complete the shipping. Now the XSER000001, XSER000002, XSER000003 are in SHIPPED Status.

14 Navigate to Serial Number Inventory, see the same Serial XSER000005 is associated with two OBLPNS one is shipped status and the other is in PACKED Status.

Fac  Comp             Serial Nbr           Item               OBLPN LPN                   status
== =======     ========== ============ ============== ==============
F1   SR_COMP     XSER000005      ITMSER0001       OBLPNTEST101          Shipped
F1   SR_COMP    XSER000005       ITMSER0001       OBLPNTEST201          Packed


Changes

 

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
Changes
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.