Cannot use fast refresh of materialized views after EBS upgrade to 12.2
We are running EBS 12.2 application and after the upgrade we are unable to have Materialized views to be created with fast refresh over db link. We need to have fast refresh for performance. EBS 12.2 requires to have #views on top of the tables for online patching. How we can combine this functionality with fast refresh?
Steps :
in EBS database
1. Create table xxabc.blah1 (I NUMBER);
2. create EDITIONING VIEW xxabc.BLAH1# as select I from xxabc.blah1;
3. create EDITIONABLE synonym apps.blah1 for xxabc.BLAH1#
4. create materialized view log on xxabc.blah1 with rowid
5. create editionable synonym apps.MLOG$_BLAH1 forxxabc.MLOG$_BLAH1;