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)

Design Overview

This shell script will refresh the RMS_OI_WAC_VARIANCE_CALC to show the change in WAC for an item/location, based on the change in the ITEM_LOC.AV_COST during the day. It is used by the WAC Variance report shown by default in the Finance Analyst dashboard.

Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad Hoc. During the Day outside the batch window.
Frequency	Every 2 hours
Scheduling Considerations	Must run after rms_oi_pricecostrefresh.ksh
Pre-Processing	N/A
Post-Processing	N/A
Threading Scheme	N/A

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