WS: 42: In Sales Order Entry (P4211) the Unit of Measure EA is Not Large Enough for Quantity (UORG) when Generating a Sales Invoice (P42565) (Doc ID 2903406.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

We have a customer that wants the Sales Invoice (P42565) to only contain the UOM of EA (each). Currently, we are in a multi-decimal environment containing three decimal positions. The size of the quantity field (UORG) is not sufficient to hold the quantity in eaches for Sales Order Entry (P4211) or Sales Invoicing (P42565).

We are looking for some control or method for increasing the size of the quantity field for Sales Order Entry (P4211), without having to customize the code.

The issue can be reproduced at will with the following steps:

1. Add a sales order for a six digit quantity. Ex: 149760.000 in a multi-decimal environment where data item class QTYINV - Inventory Quantities is greater than two Display Decimal positions.
2. Re-inquire back on the sales order and note that the quantity field now displays as 49670.00
3. Invoice the customer (P42565) and the invoice is for the quantity of 49,760.000 and not 149760.000.

The issue has the following business impact:

Users cannot enter sales orders for the full quantity of six digits.

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.