My Oracle Support Banner

Why Do Updates to Supplier Site Expense Profiles Not Update the Item Expense or Order Item Expense? (Doc ID 2009922.1)

Last updated on MAY 16, 2022

Applies to:

Oracle Retail Merchandising System - Version 13.2.6 and later
Information in this document applies to any platform.


When updating the Supplier Expense profile with a new component rate (e.g., amend % rate for freight), or changing the lading port, the changes do not get reflected in the Item Expense Detail or Order Item Expense Detail.


  1. Create a Supplier and Supplier Site.
  2. Define Supplier Expense details, including Lading Port, Discharge Port, Freight & Total Order Cost components.
  3. Create an item and range to the supplier site.  Item expenses are defaulted from the Supplier Site.
  4. Create a Purchase Order (PO) for the Supplier Site and Item created in steps 1-3.  The item order expenses should default from item expense.  Leave the order in worksheet status.
  5. Amend the Supplier Site expense profile by changing the Lading Port and a component rate (%).
  6. Note that the item expense and order expense do NOT get updated, nor does the Lading port details change.  It is expected that 'batch_itmcostcompupd' will update Item Expense Detail, and 'batch_ordcostcompupd' will update Order Item Expense detail.


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.