Decimal Precision Issue When A Job Is Completed And The Materials Are Backflushed
Last updated on MARCH 08, 2017
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.
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