My Oracle Support Banner

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 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

PROBLEM

Pick confirm fails for lot controlled items from multiple lots per transaction line with following error, and could result in on-hand quantity mismatch.

ERROR

INV:::INV_PICK_API_FAILED.oracle.javatools.resourcebundle.ResourceBundleRT

SYMPTOMS

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: 

E.g.  
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.

Case 1:
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

Case 2:
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.

Case 3:
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

Changes

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.




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.