My Oracle Support Banner

E-ORA: Start/Stop Materialized View Schedule Refresh Not Working After Database Upgrade to 19c (Doc ID 2769491.1)

Last updated on APRIL 21, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.57 and later
Information in this document applies to any platform.


On : 8.57 version, Database-Oracle

A materialized view (MV) in QA/PROD environment stopped refreshing after the database server was upgraded from Oracle 12c to Oracle 19c.

Replication steps:


1. Create a new MV using Application Designer.

2. Build and create the MV at the database level.

3. From Materialized View Maintenance page (PeopleTools > Utilities > Administration > Materialized Views > Maintain Materialized Views), check the new MV.

4. Set schedule refresh interval, save and run the PTMATREFVW process.

5. Perform the database upgrade from Oracle 12c to 19c.

6. Back to the Materialized View Maintenance page, notice that the start/stop button and interval value are greyed out and blank.

NOTE: The start/stop button and interval value should be enabled and show the value.


 The database server is upgraded from Oracle 12c to Oracle 19c.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.