My Oracle Support Banner

What Is The Impact Of Setting The System Parameter "Inventory Item For Freight = Null"? (Doc ID 2661683.1)

Last updated on APRIL 12, 2022

Applies to:

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


When migrating from 11i to R12, finding the following behavior:

In R12, it was noticed that the 'inventory item for freight' line is taking the value as “Freight”(inventory_item_id=6) in to table zx_lines_det_factors and in column
product_id, where as in 11i , Oracle treats freight as ITEM and thus sends the inventory_item_id same as that of ITEM line. Functionality needed is to have freight line to have item id same as that of item line on Order.

Setup for above functionality in system is as below in R12.

Order management->setup->system parameters -> Define -> Parameters

1- Invoice Freight as Revenue : Y
2- Inventory Item for Freight : Freight

The above parameters are not seen in 11i.
In other ERPs like 12.2.6 with the same setup as above is working as expected and are seen with freight as ITEM.

Note:- Found the functionality is working as expected only when updating the parameter 'Inventory Item for Freight' default value to NULL


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.