Monthly Stock on Hand, Retail and Average Cost Values Update (hstmthupd)
|
Module Name |
hstmthupd.pc |
|
Description |
Monthly Stock on Hand, Retail and Average Cost Values Update |
|
Functional Area |
Sales History |
|
Module Type |
Business Processing |
|
Module Technology |
ProC |
|
Catalog ID |
RMS158 |
|
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
This batch program runs monthly to update the stock on hand, retail values and average cost for each item/location on the ITEM_LOC_HIST_MTH (item location history by month) table. If the item/location does not exist on the ITEM_LOC_HIST_MTH table, then the new record is written to a comma delimited file which is later uploaded to ITEM_LOC_HIST_MTH table using SQL*Loader (hstmthupd.ctl).
Restart/Recovery
The logical unit of work for this program is the item/location record. Threading is done by store using the v_restart_store_wh view. The commit_max_ctr field on the RESTART_CONTROL table will determine the number of transactions that equal a logical unit of work. Table-based restart/recovery is used.