E1: 45: Basket and Order Repricing (R42750) Calculates Enhanced Basket Price Adjustment Incorrectly When Varying Units of Measure are Defined in Threshold Unit of Measure and Factor Value Unit of Measure (Doc ID 2872882.1)

Last updated on JULY 28, 2022

Applies to:

Symptoms

Basket and Order Repricing (R42750) is calculating an Enhanced Basket price adjustment amount by multiplying the pounds per case times the adjustment amount instead of simply adding the adjustment amount to the price per case.

Steps to duplicate:

1. In UDC 40/PI Create a new Item Group “PASTA”.
2. Create a New Item with Primary Unit of Measure = CA and Weight = 16.23 LB per CA. Set Item Price Group to “PASTA”.
3. Create an Item Base Price (P4106) of 22.08 per CA.
4. The price adjustment will be to the price per case but the adjustment will be based on the weight of the order. Setting up Basket Master (P4550) using the Weight Unit of Measure LB since that what needs to be checked to determine which adjustment detail record to use.
5. Price Adjustment Definition (P4071) settings as follows:
   1. Basket Level Adjustment
   2. Enable Basket Master
   3. Weight Level Break
   4. Manual Add/Change
   5. Apply Absolute Value
6. Create a Price Adjustment Schedule (P4070) with just the one adjustment on it.
7. Create a Price Adjustment Detail (P4072) record for the Basket Reprice Group with From Level of 5,000 LB and Basis Code 5.
8. Take the Row Exit to Adj. per Bskt Item.
9. On 5,000 LB level break the UM for the adjustment is LB and the Factor Value is 2.000.
   1. Client expects 2.00 per CA to be added to the case price not 2.00 per LB.
   2. How can we make an adjustment on the per CA price based on the weight in LB?
10. Enter a Sales order for 350 CA. Before applying the Basket Adjustment, the price comes in as 20.0800. Extended Weight is 5,680.5 LB.
11. Take the Form Exit to Reprice Order.
12. The price is changed from 20.0800 to 54.5400 per CA. The customer expected a price of 22.0800 per CA.
13. Price History shows the price adjustment was calculated as 2.00 per LB and 32.46 per CA instead of 2.00 per CA.
    1. This is because each CA weighs 16.23 LB.

Cause

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