Hello, We have a solution put in place by a consultant and I am curious what some of the experts out there think of this use of MV's.
We are using Oracle EBS and the requirement was to track order changes by week. The consultant setup materialized views on the EBS tables that we needed to track changes on. Every few hours a batch job queries the materialized view logs to see what changes have occurred and save the changes in custom tables. After all of the changes have been processed the materialized views are refreshed.
I don't have a specific issue I am trying to solve, I'm just curious if you think this is valid use of materialized views and possibly what are the some of the limitations or issues I should keep an eye out for. If you need more details let me know.
DB version: 12.1.0.2.0