Decimal Precision Issue When A Job Is Completed And The Materials Are Backflushed
(Doc ID 1671888.1)
Last updated on JULY 08, 2020
Applies to:Oracle Work in Process - Version 12.1.3 and later
Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
Mismatch in quantity precision between Inventory and Work In Process for components
The issue can be reproduced at will with the following steps:
2. WIP Parameters
3. Material Requirements
We have found what looks like a decimal precision issue when a job is completed and the materials backflushed. The following conditions create this issue:
1. BOM component item has required quantity with more than 5 digits (we have this issue mostly due to component level yields in the BOM)
2. Item is lot controlled
3. Item is set to backflush (we mainly use Operation Pull)
4. The 'Lot Selection Method' is set to 'Manual' (WIP Parameters)
The issue arises when the user is prompted to select the lot number to backflush. The user enters the backflush quantity, with all 6 decimals that are showing in the form.
Once the backflush is saved, you can see in the Material requirements for the job that the quantity was over issued by a small number – which most likely amounts to a rounding error.
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