WAC Refresh (rms_oi_wacvarrefresh.ksh)
Module Name |
rms_oi_wacvarrefresh.ksh |
Description |
Refreshes the |
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 |
Pre-Processing |
N/A |
Post-Processing |
N/A |
Threading Scheme |
N/A |