Skip to main content
Solved

Custom Materialized Views not refreshing post UPD7 install

  • July 27, 2020
  • 1 reply
  • 198 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.

View original
Did this topic help you find an answer to your question?

1 reply

Srikanth
Superhero (Partner)
Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 291 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings