OPM R12 Error INV_TRX_LOT_NA_DUE_MS When Transact Ingredient WIP Issue And Prod WIP Cmpt Together

(Doc ID 2140101.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.


When attempting to transact batch ingredient wip issue and product item wip completion transaction with pending lot at the same time,
the following error occurs.

"The Lot Number xxx of item aaa is not available for the transaction
The Lot Number is linked to a Material Status which does not allow this transaction"

The issue can be reproduced at will with the following steps:
1.Create bulk batch for Product aaa.
2.Create packaging batch for Product aaa-p, aaa is its ingredient.
3.Create a Pending lot xxx for the Bulk batch.
4.Create a Pending lot xxx for the Packaging batch.
5.Release both batches to WIP.
6.Make the WIP Completion for the Bulk batch BBB. Transact the material. Complete and Close the Bulk batch BBB.
7.Go the Packaging batch BBB-P and Transact Material for the Ingredient and WIP Completion (with the Pending lot already created) at the same time.
Entered the line for the ingredient. Didn’t click on Transact or Save, but click on the Product line and fill in the line.
When clicking on Transact the error message is shown:


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms