My Oracle Support Banner

WIP Issue Leaving Reservation Quantity that Goes Out to Six Decimal Places (Doc ID 2725314.1)

Last updated on NOVEMBER 02, 2020

Applies to:

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


On : 12.2.8 version, Batches

Item is used in a batch in its primary UOM.
Dispensing is done in the secondary UOM.
The dispensed secondary qty converts to a smaller primary qty than what was reserved to the batch.
When going to Transact Material in the batch, the transaction qty defaults to this converted quantity instead of the reserved qty.
So far, all this is correct.
When you transact, a quantity is remaining from the reservation.
The issue is that this remaining reservation quantity goes out to six decimal places (in the primary), even though Inventory supposedly only supports five decimal places.
This then causes the Available to Reserve and Available to Transact to go out to six decimal places.
It is not possible to transact six decimal places (for example on Misc Issue); if you enter six the system rounds it to five.

Expect the remaining reservation to have only five decimal places.

The issue can be reproduced at will with the following steps:
1. Ingredient in batch in primary qty. Planned qty is less than available qty for a lot
2. Reserve planned qty
3. Dispense in secondary UOM.
4. Do WIP Issue in batch.

The issue has the following business impact:
Due to this issue, available quantity has six decimal places, but six decimal places cannot be transacted. Customer has to delete the remaining reservation to get available qty back to five decimal places.




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.