Skip to main content
Solved

Custom Materialized Views not refreshing post UPD7 install

  • July 27, 2020
  • 1 reply
  • 213 views

Srikanth
Superhero (Partner)
Forum|alt.badge.img+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

Best answer by Srikanth

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.

1 reply

Srikanth
Superhero (Partner)
Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • Answer
  • July 29, 2020

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.