Aggregate Collected Planning Data

Use the Aggregate Collected Planning Data scheduled process to aggregate and store collected measure data for use in demand plans that use planning level profiles.

The Aggregate Collected Planning Data scheduled process calls these child processes:

• Aggregate Collected Planning Data: Create Snapshot of Aggregated Dimension Data
• Aggregate Collected Planning Data: Create Snapshot of Aggregated Measure Data

Note: In the Scheduled Processes work area, you can't search for and submit the Aggregate Collected Planning Data: Create Snapshot of Aggregated Dimension Data and Aggregate Collected Planning Data: Create Snapshot of Aggregated Measure Data scheduled processes.

When to Use

If you're using planning level profiles in your demand plans, then you should run this scheduled process after you collect or purge Customer dimension data or measure data at the Customer Site level for Customer dimension hierarchies. You must run the scheduled process before running the demand plans.

If you use a job set for collections, then you can add this scheduled process to the job set.

You can configure the scheduled process to run automatically after collections by using the SCP_PARAMETER_OVERRIDES profile option code. For more information, see the topic titled Automatically Submit Scheduled Processes for Planning Level Profiles.

Privileges Required

• Run Plan with Snapshot (MSC_RUN_PLAN_WITH_SNAPSHOT_PRIV)

Specifications

Specification	Description
Job Type	As required Scheduled You can automatically run the scheduled process after collections. You can also add the scheduled process to a job set.
Frequency	After you collect or purge Customer dimension data or measure data at the Customer Site level and before you run your demand plan
Time of Day	You can submit the scheduled process at any time based on your requirements. However, it’s recommended not to run the scheduled process while your demand plan is running.
Duration	The scheduled process typically takes a few minutes to complete. However, based on data and other conditions, the duration might increase.
Compatibility	There should be only one instance of the scheduled process running at any one time for a specific planning level profile in a user session.

Parameters

Parameter	Optional or Required	Description	Parameter Value	Special Combinations Required	Notes
Planning Level Profile	Required	Name of the planning level profile	The name of a planning level profile in the Enabled or Ready status ALL (if all planning level profiles in the Ready or Enabled status should be processed)	None	Only those planning level profiles in the Enabled or Ready status can be viewed and selected.
Type	Required	Type of the run for the scheduled process	Net change Targeted	None	Select Net change when you want to aggregate only the data for the Customer dimension and measure data at the Customer Site level that's been collected since the scheduled process was last run. Select Targeted when you want all the Customer dimension data and measure data at the Customer Site level to be aggregated.

Troubleshooting Information

• You can view the status of the scheduled process in the Scheduled Processes work area.
• If the scheduled process takes a long time to run, click Cancel Process, and then click Resubmit.
• The errors and warnings for the scheduled process are displayed in a log file.

  No warnings are displayed for you to perform actions while the scheduled process is running.

• If the scheduled process doesn't run successfully, review the error messages in the log file.
• If the reason for the failure isn't clear, review the diagnostic log files and contact Oracle Support.