MTL_ITEM_CAT_SN and DIRLOAD_DML

Posted by Linda on Jan 10, 2017; 10:57pm
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/MTL-ITEM-CAT-SN-and-DIRLOAD-DML-tp1885.html

Hi Erman!
I have interesting issue:
patch 23748901 applied to downgrade MTL_ITEM_CATEGRORIES to NOT BE seed data table and the refresh should go fast.
In patch was run :exec AD_ZD_SEED.DOWNGRADE('MTL_ITEM_CATEGORIES');
Now:
select ad_zd_table.is_seed('INV','MTL_ITEM_CATEGORIES') from dual
AD_ZD_TABLE.IS_SEED('INV','MTL_ITEM_CATEGORIES')
--------------------------------------------------------------------------------
N
Recreated those snapshots
MTL_ITEM_CAT_SN should  NOW be  fast_refreshable='DIRLOAD_DML'
the same  as MTL_DEMAND_SN.
select fast_refreshable from  dba_mviews
where mview_name like 'MTL_ITEM_CAT_SN';
FAST_REFRESHABLE
------------------
NO

SO, DB has desided that MTL_ITEM_CAT_SN is NOT fast_refreshable, the setup of objects  after patch looks like similar  MTL_DEMAND_SN.  
I run that analyze  DBMS_MVIEW.explain_mview  on the the MTL_ITEM_CAT_SN and the aswer is "does not meet the requirements of a primary key mv" LOL :)
Any guesses why RDBMS still think that ?
Any hints ? I think its about still that table MTL_ITEM_CATEGORIES.. but why :)
Thanks alot for reading this..
Br,Linda