Retain Item Forecast History (rms_oi_forecast_history.ksh)

Module Name	rms_oi_forecast_history.ksh
Description	Retain 4 weeks of Item Forecast History
Functional Area	Item Forecast, Inventory Analyst Report
Module Type	Admin
Module Technology	Ksh
Catalog ID	RMS491
Wrapper Script	rmswrap_shell.ksh

Schedule

Oracle Retail Merchandising Batch Schedule

Design Overview

This batch program preserves four weeks of weekly forecasted sales data, moving the data from the item forecast table to the item forecast history table. The item forecast table is truncated and refreshed by the load_item_forecast.ksh weekly batch program.

The data in the history table is used to support the Inventory Variance to Forecast report in the Inventory Analyst dashboard. If the system is not configured to use this report, then running this batch job will NOT copy any data to the history table.

To support potentially large volume of data on the item forecast and item forecast history tables, the history table is interval partitioned by end of week date with a partition interval of 7 days and an interval high value of end of week date + 1. End of week date must be a valid end of week date based on calendar type - (4) 454 or (C) Standard Calendar.

Restart/Recovery

N/A

Key Tables Affected

Table	Select	Insert	Update	Delete
ITEM_FORECAST	Yes	No	No	No
ITEM_FORECAST_HIST	No	Yes	No	Yes

Design Assumptions

N/A