My Oracle Support Banner

Data Collections Refresh Snapshots Fails Trying To Refresh MTL_ITEM_CATS_SN In First Run Of Data Collections (Doc ID 1160432.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.


12.1.2 APS destination
11.5.10 EBS source with data collections rollup #32

MTL_ITEM_CATS_SN does not use MSC_COLLECTED_ORGS.  Customer has 187 million rows in MTL_ITEM_CATEGORIES, customer has 429 orgs.  Customer is only collecting 6 org and only need to collect about 800K rows for this snapshot.

Need to use MSC_COLLECTED_ORGS in this snapshot to reduce rows.

We are having other problems due to size of this snapshot - 187 million rows.

Run complete refresh of the snapshot to get started with data collections.
This will not complete with 187 million rows due to standard database functionality.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.