ALERT: After 19-APR-2019 Weekly, Pick Confirm Fails With "INV:::INV_PICK_API_FAILED.oracle.javatools.resourcebundle.ResourceBundleRT"
(Doc ID 2537318.1)
Last updated on NOVEMBER 28, 2019
Applies to:Oracle Fusion Inventory Management Cloud Service - Version 11.13.19.01.0 and later
Oracle Fusion Manufacturing Cloud Service - Version 11.13.19.01.0 and later
Oracle Fusion Inventory Management - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Pick confirm fails for lot controlled items from multiple lots per transaction line with following error, and could result in on-hand quantity mismatch.
The issue identified has the following symptoms:
1. Currently this is observed to occur only when the weekly maintenance pack on or after April 19th has been applied either on release 13 update 19A/19B.
2. The issue is observed for pick confirm/transfer/issue lot controlled items with multiple lots per transaction lines. But impact on non-lot controlled items is still to be determined.
sales Order/inter-organization transfer/miscellaneous issue/sub-inventory transfer/manufacturing or maintenance/transfer order pick confirm transactions with multiple lots are impacted.
Listed below is a use case to understand the issue:
Total On-hand: 100 (Lot_1 = 30 and Lot_2 = 70)
Order quantity: 100
2 Lots are assigned for the Transaction: Lot_1 and Lot_2
Lot_1 Quantity assigned is 30, Lot_2 Quantity assigned is 70
When attempting to perform the transactions using Confirm Picks UI, system will always try to issue the full order quantity (100) from each lot. Below are the details.
If the Inventory Organization attribute 'Allow negative on-hand transactions' is unchecked, system will not allow to perform this transaction and will throws the following error:
Error Message: INV:::INV_PICK_API_FAILED.oracle.javatools.resourcebundle.ResourceBundleRT
However, if 'Allow negative on-hand transactions' is enabled, then it will allow the transaction to go through and cause data corruption as well as on-hand Quantity mismatch.
In this case it will issue 100 from Lot_1 and 100 from Lot_2, causing on-hand to become negative.
Now assuming Total On-hand Quantity is 200 (Lot_1 = 100 and Lot_2 = 100)
If on-hand available quantity is greater than the Transaction quantity, transaction will go through and may cause a data corruption.
In this case it will issue 100 from Lot_1 and 100 from Lot_2, causing on-hand to become 0.
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. Navigate to Supply Chain Execution > Inventory Management
2. Task list > Confirm Pick Slips
3. Search for the Sales Order Number
4. Open the Pick Slip
5. Select Ready to Confirm on the lines with multiple lots
6. Select Confirm in the upper right
7. Issue occurs
19A/19B weekly maintenance pack update on 19-APR-2019 and later introduced this issue, i.e. either GSI_REL13.1901-20190419, GSI_REL13.1901-20190426 or later.
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