Automatic Order Level Freight Modifier Based on Order Weight Qualifier Is Not Working (Doc ID 1293066.1)

Last updated on JUNE 05, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Checked for relevance on 13-JUL-2015

Symptoms




On : 11.5.10.2 version, Pricing, Discounting & Charges

Find Order Weight Modifier is not working.

EXPECTED BEHAVIOR
-----------------------
Expect Order Weight modifier to apply.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Order Weight Modifier not working.
Modifier Type: Misc/Freight Charge-US Modifier Type: Freight and Special charge Currency: USD
Charge Name: FREIGHT/MISC CHARGES
Applictaion method: Lumpsum
Value: 25

Line-Level Qualifier:

Grouping Number Qualifier Context Qualifier Attribute Precedence Operator Value From Value To
-1 Customer Customer Name 260 = STAPLES INC -FRAMINGHAM MA
-1 Volume Order Weight 640 BETWEEN 0 59.99
-1 Order Order Type 470 = STANDARD


After setting this modifier we did the following:
1) Profile QP: Line Weight UOM Code is set as LBS in Site Level
2) Run "Build Attribute Mapping Rules "
3) Run "QP: Maintains the denormalized data in QP Qualifiers"

Order  is entered into system has no freight charges although it satisfies all qualifiers for the Modifier.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot freight properly.

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