Shipping Charge Modifier Using Order Amount Qualifier Is Not Working Correctly

(Doc ID 1372531.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Oracle Order Management - Version and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Form:OEXOETEL.FMB - Quick Sales Orders


Find an automatic order level freight charge with order amount
as a qualifier is not working correctly when a discount modifier(s)
has been applied.

Expect the freight charge modifier to be applied based on order amount.

The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User (or equivalent)
2. Navigate to: Orders, Returns > Sales Order
3. Enter sales order and one order line.
    List price on the order line is 249.99 and quantity is 1.
    Order subtotal = 249.99
    Freight charge 9.95 is applied which is qualified by order amount between 100 and 999999999
    --So far all looks fine.
4. The unit selling price on the order line is manually updated to 49.99
    Hence new order subtotal = 49.99
    But the freight charge is still 9.95
    Expects freight charge should be 5.95 which is qualified by order amount between .01 and 100

The issue has the following business impact:
Shipping Charge is being calculated incorrectly; customer can be charged wrong amount.


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