Freight Terms Are Not Defaulting When One Imports Orders In BOOKED Status (Doc ID 2251597.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Pricing, Discounting & Charges

ACTUAL BEHAVIOR
---------------
Find that using order import to bring in a new sales order and have it booked,
does not correctly evaluate and apply modifiers. Term substitution modifier is setup with qualifiers,
one being order amount = 0. When term substitution modifier is applied, it will set freight terms = "NO CHARGE".

However, when order is imported in booked status,  modifier is always being applied, even when the order amount is > 0.
The "CONTEXT PASSED" is always 0 (zero) as shown in the debug log file.

EXPECTED BEHAVIOR
-----------------------
Expects the term substitution modifier, TERMS-ZERO_ORDER_FEDEX (list_line_id 14684168 ),
to be applied only when all qualifiers are met. Expects the order amount to be the subtotal value on the sales order being created.


WHAT DOES WORK
------------------------
Take identical orders and import the 1st order without populating the oe_headers_iface_All.booked_flag,
The order is imported as an "Entered" order. The defaulting rules populate the freight terms with the expected
value as per the examples in the screen shot per order 3736866.
A copy of the order above when imported as a "Booked" order by populating the oe_headers_iface_All.booked_flag = 'Y',
the freight terms always change to "NO CHARGE" per order 3736867.
See file Screen_shots_for_orders_3736866_and_3736867_with_View_Adjustment.docx.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the OE interface tables
2. Run order import
3. Check the order created.
  Responsibility: Order Management Super User (or equivalent)
  Navigate to: Orders, Returns > Sales Orders
  Query the order
4. Find that even though the order subtotal is greater than zero,
  the term substitution modifier, TERMS-ZERO_ORDER_FEDEX (list_line_id 14684168 )
  is applied. Therefore the freight terms = 'NO CHARGES' is shown on the order header and order lines/shipping tab.



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