Re: MTL_ITEM_CAT_SN and DIRLOAD_DML

Posted by ErmanArslansOracleBlog on Jan 12, 2017; 7:49am
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/MTL-ITEM-CAT-SN-and-DIRLOAD-DML-tp1885p1898.html

Hmmm....
So, you say, you will Refresh Collection Snapshot program.
That will run Crete INV Snapshots program and it will recreate MTL_ITEM_CATS_SN and snapshot logs on MTL_ITEM_CATEGORIES.
and after that you will check the MTL_ITEMS_CATS_SN and see if it is created with rowid and see if it is fast freshable right?


Ref:

- On the Source instance set the profile MSC: Source setup required to Y
- On the Source instance - Run Refresh Collections Snapshots parameter Mode = Fast
This will launch the Refresh Collections Snapshot program which will in turn launch a series of requests that will check APS objects and recreate them as required.  For example: Create INV Snapshots program which will recreate MTL_ITEM_CATS_SN and the snapshot log (MLOG) on MTL_ITEM_CATEGORIES


Okay.
Keep me updated on this...