Re: MTL_ITEM_CAT_SN and DIRLOAD_DML

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/MTL-ITEM-CAT-SN-and-DIRLOAD-DML-tp1885p1891.html

Hi Linda,

Another interesting and hard problem from you :) But it is good to deal with these kinds of issues..

I m checking it in my 12.2.4 instance and it is fast_refreshable..

SQL> select fast_refreshable from  dba_mviews where mview_name like '%MTL_ITEM_CATS_SN%';    2
FAST_REFRESHABLE
------------------
DIRLOAD_DML

Note that, Patch 23748901 is not applied to this env, but the MTL_ITEM_CATEGORIES is not a seed table.

SQL> select ad_zd_table.is_seed('INV','MTL_ITEM_CATEGORIES') from dual;
AD_ZD_TABLE.IS_SEED('INV','MTL_ITEM_CATEGORIES')
--------------------------------------------------------------------------------
N


I think it is fixed in EBS 12.2.4.

Anyways;


Can you please execute the check documented in the following support note and send me the "exact output":

How to Use DBMS_MVIEW.EXPLAIN_MVIEW to Check for Fast Refresh Options? (Doc ID 730908.1)