Solved

Custom Materialized Views not refreshing post UPD7 install

  • 27 July 2020
  • 1 reply
  • 164 views

Userlevel 6
Badge +18

Hello,

I installed Apps 10 UPD7 update recently for a client and everything went well barring one issue.

We noticed none of the custom Materialized Views are updating automatically post update in spite of Next Refresh parameter reflecting future date and time. Manually refreshing the MVs works fine, so no issue with the code or objects.

Has anyone encountered this behaviour before?

TIA

icon

Best answer by Srikanth 29 July 2020, 17:47

View original

1 reply

Userlevel 6
Badge +18

We figured this one and had to re-enable the underlying Oracle job to get them to refresh automatically. 

Hope this helps someone running into the same issue.

Reply