Pricing Cost Refresh (rms_oi_pricecostrefresh.ksh)

Module Name	rms_oi_pricecostrefresh.ksh
Description	Refreshes the MV_PRICING_COST to reflect the most recent pricing cost of an item/location in FUTURE_COST.
Functional Area	Financial Dashboard
Module Type	Admin
Module Technology	Ksh
Catalog ID	RMS477
Wrapper Script	rmswrap_shell.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This shell script will refresh the pricing cost materialized view snapshot to reflect the most recent pricing cost for an item/location in from the future cost table. It will in turn insert/update into the WAC variance calculation table to reflect the change in WAC as a result of the change in the average cost of an item/location. This information is used by the WAC Variance report displayed by default in the Finance Analyst dashboard.

Restart/Recovery

N/A

Key Tables Affected

Table 9-3 Key Tables Affected

Table	Select	Insert	Update	Delete
RMS_OI_WAC_VARIANCE_CALC	Yes	No	Yes	No
MV_PRICING_COST	Yes	No	No	No
ITEM_LOC_SOH	Yes	No	No	No
STORE	Yes	No	No	No
WH	Yes	No	No	No
CURRENCY_RATES	Yes	No	No	No

Design Assumptions

N/A