My Oracle Support Banner

How APCC Gather Profiles Work (Doc ID 1940154.1)

Last updated on OCTOBER 10, 2017

Applies to:

Oracle Advanced Planning Command Center - Version 12.1.3 and later
Information in this document applies to any platform.


Archive Plan Summary loads the data into APCC tables. Need to understand how the following APCC profiles will work.
In one article, it said Profile is used for gathering table stats on fact tables. However if one sets the value to "Yes" for these profiles, then they are not able to find any program running in the backend.
Need to understand after setting these profiles, Which program takes them into account? How gather stats will be applied on APCC Fact tables,APCC Staging tables?

MSC: APCC Gather Fact Tables Statistics
MSC: APCC Gather Intermediate Tables Statistics
MSC: APCC Gather Plan Tables Statistics


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.