6.3 Maintaining Materialized Views

For ongoing maintenance of materialized views, administrators can use the Materialized View Maintenance page (PTMAT_MAINT). Administrators must have the Materialized View Administrator role and permission list to access this page. Access the Materialized View Maintenance run control page.

Navigate to PeopleTools, Utilities, Administration, Materialized Views, Maintain Materialized Views.

Figure 6-3 Materialized View Maintenance

This page contains a grid that is populated with a list of the records in the materialized views table, PSPTMATVWDEFN .

See PeopleSoft PeopleTools: Data Management, “Administering PeopleSoft Databases on Oracle”, Using Materialized Views.

When you click the Run button, the PTMATREFVW Application Engine program executes. It brings up the Process Scheduler Request page. Enter the appropriate server on the page and click the OK button to initiate the process.

Figure 6-4 Process Scheduler Request page