My Oracle Support Banner

Shipping Charge Modifier Using Order Amount Qualifier Is Not Working Correctly (Doc ID 1372531.1)

Last updated on MAY 07, 2020

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


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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