My Oracle Support Banner

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

Last updated on SEPTEMBER 07, 2021

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:
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.




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.