E1: 45: Detached Adjustment Totals Calculating Incorrectly Due to Rounding (Doc ID 2815887.1)

Last updated on JUNE 10, 2022

Applies to:

Symptoms

Detached price adjustments are not rounding up to the nearest 0.01 in some orders where item primary Unit of Measure is EA, but Pricing Unit of Measure is 6P (6 pieces) and the adjustment is expresses as a percentage. For example an adjustment calculated as 1% of 14.50 is calculated as 0.14 instead of being rounded up to 0.15. The result is a 0.01 rounding difference between the customer's purchase order and the E1 sales order on approximately 100 production orders per day. Accounting workarounds are needed to correct the discrepancy.

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

1. Item Primary UOM is EA
2. Secondary and Pricing UOM is 6P
3. Conversion: 1 "6P" = 6 "EA"
4. Detached Price Adjustment Definition (P4071) has Quantity Level Break selected.
5. Base Price (P4106) is in UOM "6P" and is $2.90 per "6P" (same as 4.833333333333 per EA)
6. Price Adjustment Detail (P4072) is Basis Code 1, Factor Value = -1% for UOM "6P"
7. Sales Order is created as follows:
     a. Order Quantity is 5 "6P" units (60 EA)
     b. Unit Price on Sales Order is $2.90 per "6P"
     c. Extended Price on Sales Order is $14.50
     d. Detached Adjustment calculates as -1% of Extended Amount as -0.14 instead of -0.15.
   
   

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.