Volume Offer Accruals Are Not Correct When Order UOM And Pricing UOM Are Not Same (Doc ID 2096697.1)

Last updated on JUNE 09, 2017

Applies to:

Oracle Trade Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Offers

Incorrect accruals are created by Volume Offer When Order UOM And Pricing UOM Are Not Same

TEST CASE
---------------
Create Products with - 
Primary UOM - Pounds
Secondary UOM - Each

UOM conversions -
1 CWT = 100 Pounds
1 TON = 2000 Pounds

1 TON = 20 CWT in the order

Price List - Corporate
UOM = CWT,
Primary UOM - checked
Price = 10

Create volume offers VO_1 and VO_2 with tiers -
Tiers By - Quantity, Discount By - Amount, UOM - CWT
0 - 100 1
100 - 200 2
200 - 999999990000000 5

Products -
ITEM - 1 - Apply Discount = checked, Include Volume = checked
ITEM - 2 - Apply Discount = not-checked, Include Volume = checked

Check Retroactive in Market Options

Booked and Shipped Order with 2 order lines -
1.1 ITEM - 1 1 TON / Pricing Quantity = 20 CWT
2.1 ITEM - 2 5 TON / Pricing Quantity = 100 CWT

Accrual for VO_1 falls in 2nd tier <<CORRECT>>
Accrual for VO_2 falls in 3rd tier <<INCORRECT>>

Volumes in ozf_volume_summary for VO_1 - 119.9999. Correct volume should be 120 <<ISSUE>>
Volumes in ozf_volume_summary for VO_2 - 6473.99461. Correct volume should be 120 <<ISSUE>>

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms