Forecast Roll Up Refresh Views (refreshmview.ksh)

Module Name	refreshmview.ksh
Description	Refreshes dept_sales_forecast, class_sales_forecast and subclass_sales_forecast materialized views
Functional Area	Financials
Module Type	Adhoc
Module Technology	ksh
Catalog ID	N/A
Runtime Parameters	Database connection, Materialized View Name, Nested(Valid values: Y - True and N - False).

Design Overview

This is a batch job that will refresh the specified materialized view. The materialized views refreshed are dept_sales_forecast, class_sales_forecast and subclass_sales_forecast.

This program will be run Adhoc and will accept materialized view name as the parameter. Nested refresh of the materialized view can be controlled using the optional parameter. By default, the refresh is nested.

Scheduling Constraints

Schedule Information	Description
Processing Cycle	Ad Hoc
Frequency	As Needed
Scheduling Considerations	It is a Adhoc
Pre-Processing	N/A
Post-Processing	N/A
Threading Scheme	N/A

Restart/Recovery

N/A

Key Tables Affected

Table	Select	Insert	Update	Delete
ITEM_FORECAST	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
STORE	Yes	No	No	No
SUBCLASS_SALES_FORECAST	Yes	No	No	No
CLASS_SALES_FORECAST	Yes	No	No	No
DEPT_SALES_FORECAST	Yes	No	No	No

I/O Specification

N/A