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

Design Overview

This shell script will refresh the MV_PRICING_COST snapshot to reflect the most recent pricing cost for an item/location in FUTURE_COST. It will in turn insert/update into the RMS_OI_WAC_VARIANCE_CALC to reflect the change in WAC as a result of the change in the ITEM_LOC.AV_COST of an item/location. This information is used by the WAC Variance report displayed by default in the Finance Analyst dashboard.

Scheduling Constraints

Schedule Information	Description
Processing Cycle	Every 6 AM outside the batch window.
Frequency	Daily
Scheduling Considerations	Must run before rms_oi_wacvarrefresh.ksh
Pre-Processing	N/A
Post-Processing	N/A
Threading Scheme	N/A

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