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

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.

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.



Cause

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