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 JUNE 28, 2017

Applies to:

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

Symptoms

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.

STEPS:
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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms