Freight Terms Are Not Defaulting When One Imports Orders In BOOKED Status
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.
On : 12.1.3 version, Pricing, Discounting & Charges
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms