E1: 45: Batch Cost/Price Update R42950 Wrongly Applies Adjustment for Dual UOM Item (Doc ID 2745576.1)

Last updated on APRIL 05, 2023

Applies to:

Symptoms

A sales order for a Dual UOM item has the sales price incorrectly calculated by the R42950 when set to process the price update; a line-level adjustment that (correctly) does not get applied at P4210 sales order entry, because of order quantity, is then erroneously applied by R42950.

Steps to duplicate:

1. Set the System Constants (P41001) to use value <2> (Pricing UOM) in the`Sales Price Retrieval UOM' field.
2. Add or identify a Dual UOM item (set in the Item Master P4101) where the Primary UOM is LB and the Pricing UOM is CA, add conversions in P41002. Adjust quantity in using P4114; set a base price in P4106.
3. Add a simple line level adjustment for customer/item, with the UOM set in CA (Pricing UOM) where a quantity from 1 CA to 74 CA intentionally adds $1 million to the unit price and then no value is added from 75 CA and up. The amount on the adjustment leads to an inflated price and is used as a warning, to ensure sufficient quantity is ordered on each line.
4. Raise a sales order for a quantity under 75 CA and ensure the adjustment is applied; increase the quantity above 75 CA and observe that the inflated price is removed. Save the order with this 75 CA quantity.
5. Configure a version of R42950 (batch price/cost update) with the flag for ‘Price Based on Original Quantity’ set to value 1. The option to update price is set, cost and exchange rate are not set.
6. Run the R42950 over the order created in step 4. Observe that the PDF shows the $1 million value has been added to the order line, despite there being no change in quantity on the order. 
7. Logs indicate that a quantity calculation of 74.99 is produced by the system, as this quantity is under the 75 CA threshold, the adjustment is applied.

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.