Friday, October 14, 2016

12c: Updates to Fast-Refresh Materialized Views with joins are lost after DB upgrade

An interesting article on My Oracle Support, "Updates Lost to Fast-Refresh Materialized Views with Joins After Upgrade to 12c" from document ID 2186836.1, tells us that an upgrade from 12.1.0.1 to 12.1.0.2 can negatively impact your fast-refresh materialized views with joins!  It seems that the system "covers up" the problem by having the last update date updated while the data does not get updated!!

Monday, October 10, 2016

The Return of the King!

No I am not talking about Elvis, J. R. R. Tolkien, or even Peter Jackson!  It has been a few months since I last posted, but I am back and ready to reclaim my throne of being a leading expert on the Oracle e-Business Suite application!!  In the last 6 months I have been thinking quite a bit about the future of the blog, and how best to deliver content, but I have not made any changes or decisions right now beyond the fact that I do not think I can do another 365 days straight of posting.  I am going to target 3-5 posts per week, and if I meet the target, or miss it, I am not going to let it discourage me going forward into the next week!