My Oracle Support Banner

Negative Delta Quantity Remains In The From Operation Queue While Over Receiving When The Quantity Has A Value At 6 Digits Precision. (Doc ID 3066437.1)

Last updated on JANUARY 08, 2025

Applies to:

Oracle Work in Process - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

For an Outside processing(OSP) operation, negative delta quantity remains in the From Operation Queue while Over Receiving when the Quantity has a value at 6 digits precision.
For example, 0.09 OSP resource is required for one assembly item. When creating a discrete job for the item with qty 33,
Req/PO is created with qty:2.97. Then receipt is performed with qty:3 (over receipt).
It causes over completion qty:0.33333(5th decimal place) and total completed quantity 33.333333(6th decimal place).
As a result, Qty:-0.000003 remains In Queue .
There shouldn't be any negative quantity in the from operation Queue

Steps

  1. Setup:
    One OSP resource is assigned to the operation.
    UOM Type:Resource
    Charge Type:PO Move
    Basis:Item
    Usage Rate:0.09
  2. Create a discrete job with qty:33.

  3. A requisition created with qty:2.97 (0.09*33)

  4. Autocreate a purchase order.

  5. Receipt the purchase order with qty:3(over receipt)

  6. Run WIP Move Transaction Manager.

Cause

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
Symptoms
Cause
Solution
References


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