Enabling Materialized Views

Access the Change Properties page (PeopleTools, and then Utilities, and then Administration, and then Materialized Views, and then Enable Materialized Views).

You can enable or disable the materialized view feature on an application delivered view.

Change Properties page allows you to select views to enable or disable materialized views on them.

Change Properties page for Oracle platform

Field or Control	Description
Enable?	Select to convert the view to a materialized view.
Disable?	Select to convert a materialized view to a normal SQL view.
Materialized View	Search and select the view. You can use the prompt to select the name.
Status	Displays enabled if the views are already selected to enable the materialized view feature. Displays disabled if the materialized views are already selected to disable the materialized view feature.
Object Type	Displays the current status of the view as materialized or normal SQL view.
Stop Online Refresh	Select to restrict the view from getting refreshed automatically. Note: Select to stop Pivot Grid initiated materialized views for automatic refresh.

Note:

Once you enable materialized views from PIA, go to the PeopleSoft Application Designer and build record to create the materialized view. Similarly, once you disabled the materialized views from PIA, go to the PeopleSoft Application Designer and build record to create the normal view.