My Oracle Support Banner

ORDERED_QUANTITY Changed When Updated Warehouse On Sales Order Line (Doc ID 2816934.1)

Last updated on NOVEMBER 02, 2021

Applies to:

Oracle Order Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

After upgrading to 12.2.10 version, when changing the warehouse at line level, a decision message is popping up on the screen with the following message:

Apply converted quantity to primary quantity?

If we click "No", system doesn't update the primary quantity.
If click "Yes"the ordered quantity is changed upon the rounded secondary quantity.

This Decision Box only started appearing after the application upgrade, now there is a risk that sales order users can press "Yes" and Primary Quantity will change without even their notice.
What is happening is Secondary Qty is being calculated by using UOM Conversion on Primary QTY on line entry (which is fine) -
AND on warehouse update again Primary QTY is being re-calculated by using UOM Conversion on Secondary Qty, which is creating rounding off differences in decimals.

Tried the following
"'OM: Default Secondary QTY Without Requiring User Confirmation" to "Yes"
1- Decision box does NOT appear.
2- But issue persists. The line quantity changed to 9.99999 after changing warehouse and saving.

"'OM: Default Secondary QTY Without Requiring User Confirmation" to "No"
1- Decision box appear.



EXPECTED BEHAVIOR
-----------------------
 Primary QTY should not be re-calculated and Decision box should NOT appear to avoid any possible risk

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. update Warehouse
"'OM: Default Secondary QTY Without Requiring User Confirmation" to "Yes"
1- Decision box does NOT appear.
2- But issue persists. The line quantity changed to 9.99999 after changing warehouse and saving.

"'OM: Default Secondary QTY Without Requiring User Confirmation" to "No"
1- Decision box does appear.



Changes

 Recent upgrading to 12.2.10

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