My Oracle Support Banner

Reservation not Updated Correctly When Creating Two Lot Records in One Transaction on Issue Ingredient Mobile Page (Doc ID 1909458.1)

Last updated on FEBRUARY 06, 2020

Applies to:

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


On : 12.1.3 version, Batches, Mobile

When using the <Next Lot> button on the Issue Ingredient mobile page, and transacting the same lot again, so that two lot records are created in a single transaction, only the lot quantity entered on the first lot record is subtracted from the reserved quantity.

Each lot record's quantity should update the reservation

The issue can be reproduced at will with the following steps:
Note: Form function parameter is set to TXN_MODE=BOTH
1. Create a fully detailed reservation for an ingredient in a batch
2. On Issue Ingredient page, enter N for Use Rsrv field
3. Enter the same subinventory, locator, and lot as on the reservation. The Use Rsrv field changes automatically to Y
4. Enter a lot quantity that is less than the reserved quantity, and press <Next Lot>
5. Enter the same lot, and again a quantity less than the reserved quantity, and then press <Done>
6. The reservation is only decremented by the first lot quantity

The issue has the following business impact:
Due to this issue, reserved quantity is not being updated correctly, and Available to Reserve and Available to Transact are being driven negative.

Note that if you initially select Y for the Use Rsrv field, the <Next Lot> button is hidden, but it remains on the form and can be used if you select N for Use Rsrv but then it gets updated to Y when the data you enter is the same as the data on the reservation.

The scenario about is the way the customer was able to reproduce the issue. With a personalization that hides the <Next Lot> button, however, they sometimes still get the two lot records in a single transaction, with the reservation only being updated by the quantity of the first lot record.


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

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