WAC Refresh (rms_oi_wacvarrefresh.ksh)

Module Name	rms_oi_wacvarrefresh.ksh
Description	Refreshes the RMS_OI_WAC_VARIANCE_CALC with WAC update on an item/location
Functional Area	Financial Dashboard
Module Type	Admin
Module Technology	Ksh
Catalog ID	RMS478
Runtime Parameters	$UP (database connect string)

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This shell script will refresh the WAC variance calculation table to show the change in WAC for an item/location, based on the change in the item/location's average cost during the day. It is used by the WAC Variance report shown by default in the Finance Analyst dashboard.

Restart/Recovery

N/A

Key Tables Affected

Table 9-5 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