My Oracle Support Banner

Computation Of BASE_COST Column Of FUTURE_COST Table In RMS - Functionality Clarification (Doc ID 1145804.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.1 and later
Information in this document applies to any platform.
Checked for Relevance 23 Jan 2012
Checked for relevance on 22 - December - 2014
checked for relevance on 15-Nov-2016


Functionality clarification for computation of BASE_COST column of FUTURE_COST table in Retail Merchandising System (RMS)

Questions and Answers

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
Questions and Answers
 BASE_COST is the Original Cost of the Item, which would be the same as UNIT_COST of ITEM_SUPP_COUNTRY table. Is BASE_COST of FUTURE_COST table equal to UNIT_COST of ITEM_SUPP_COUNTRY table ?
 If there are multiple locations for the same item supplier, will BASE_COST of FUTURE_COST table be modified as FUTURE_COST and stored at item/location/supplier level?
 Data model also says  "Base cost of the SKU/supplier/country at the given location", kindly confirm.
 Does BASE_COST of FUTURE_COST table would remain unaffected throughout the life of the item and if it is the first unit cost user enters in ITEM_SUPP_COUNTRY?
 Kindly confirm if the UNIT_COST of ITEM_SUPP_COUNTRY table will be updated when I do cost changes. If yes, then will BASE_COST of FUTURE_COST table also be updated for cost changes?
 If the above is true,Where can the first UNIT COST be found ?
 When will PRICING_COST in FUTURE_COST table be changed?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.