My Oracle Support Banner

RUA Done for Items Having Mass UOM is Adjusting Quantity to an Integer (Doc ID 2047034.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Invoice Matching - Version 13.2.4 and later
Information in this document applies to any platform.


When Receiver Unit Adjustment (RUA) is done for items having mass UOM and decimal quantity, it was creating an entry into TRAN_DATA with quantity truncated to an integer value.

Steps to Reproduce:

  1. Create an order.
  2. Ship and receive the order.
  3. Create an invoice having quantity greater than order in fractional terms (for example, if order qty is 30, create an invoice having quantity as 50.76).
  4. Run automatch batch.
  5. The invoice comes under URMTCH status.
  6. Try to resolve qty discrepancy for the discrepant item with a fractional adjustment value, considering invoice cost as correct.  Adjustment code should adjust the PO and receipt quantity.
  7. Check TRAN_DATA for the RUA entry.  The adjustment done is only for 20 quantity instead of 20.76.


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.