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
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 |
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 on the basis of 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, on the basis of 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 |
|
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 |
|
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 on the page for scheduled processes.
- If the scheduled process takes a long time to run, click the Cancel Process button, and then click the Resubmit button.
- 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 isn't successfully run, review the error messages in
the log file.
If the reason for the failure isn't clear, review the diagnostic log files with the help of My Oracle Support.