How APCC Gather Profiles Work (Doc ID 1940154.1)

Last updated on MAY 10, 2016

Applies to:

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

Goal

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
 

Solution

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