Decimal Precision Issue When A Job Is Completed And The Materials Are Backflushed (Doc ID 1671888.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Mismatch in quantity precision between Inventory and Work In Process for components


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. WIP
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.

Changes

Cause

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