Cancellation Of Transaction In MSCA Pick Confirmation Page For Serial Controlled Item Results In Serial And Onhand Mismatch (Doc ID 2989438.1)

Last updated on DECEMBER 01, 2023

Applies to:

Symptoms

Cancellation of transaction in MSCA pick confirmation page for serial controlled item results in serial and onhand mismatch and causing data corruption. Users are not able to use the serial as it is getting locked under a wrong subinventory/locator.

The issue can be reproduced at will using following steps.

1. Login to MSCA
2. Go to pick confirmation screen. (Material & Mfg -> Pick/Ship -> Pick Confirm)
3. Enter details. Let us assume that the total quantity on move order is 2.
4. When the system asks to confirm the serial, enter the serial as Test1. (Assuming Test1 is available as serial in the system).
5. Click Ok.
6. It asks second serial, again enter Test1. System will not accept it.
7. Click cancel button.
8. System shows message as "Txn Success".
9. Go to serial number form (Inventory -> On-hand availibility -> Serial Numbers)
10. Find that serial subinventory is already changed to staging although transaction was cancelled. Whereas Onhand is still showing in main subinventory. 

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.