Freight Term Substitution ( TSN ) Modifier Line With a Freight Term Qualifier Flips Between Applied And Unapplied Status Upon Update on Order Line (Doc ID 1465928.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 and later
Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
---------------
Find that a freight terms substitution (TSN) modifier is applied at booking but is removed
when the ordered quantity on the order line is updated or the ship-to is updated.

EXPECTED BEHAVIOR
-----------------------
Does not expect the TSN modifier to be removed upon update of the ordered quantity.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate to: Orders, Returns > Sales Orders
3. Enter a sales order/sales order line where this modifier is applicable based on the freight term value (with Freight terms =’Third Party’)
4. Save. Confirm freight term is updated and modifier is applied. (Freight terms = no charge)
5. Update the ordered quantity on the order line save.
6. Now one finds that the original value for the freight term is returned and this modifier is no longer applied. (Freight terms =’Third Party’)
7. Update the ordered quantity on the order line save.
Now the modifier is once again applied and the correct (updated) freight terms are shown.(Freight terms = no charge)

MODIFIER SETUP
-------------------------
Modifier type = Promotion
Active and Automatic are checked
Under Modifiers Summary tab:
   Level = Line
   Modifier Type = Term Substitution
   Automatic is checked
   Pricing Phase - Modifiers for BOOK Event
Under Promotional Terms tab:
   Terms Attribute = Freight Terms
   Terms Value = 'No Charge'
Under Line Qualifiers button:
   Grouping No = 10
      Qualfiier Context = Terms
      Qualfiier Attribute = Freight Terms
      Operator: =
      Value From ='Third Party'



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
It slows the CSRs down since they have to be extremely careful or we might not give the customer free frieght even though we are supposed to.
In some cases we can be fined for this.

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