Data Collections Refresh Snapshots Fails Trying To Refresh MTL_ITEM_CATS_SN In First Run Of Data Collections
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.
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.
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