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