1. Using Supply Chain Collaboration
  2. Overview of Aggregation Schedules

Overview of Aggregation Schedules

Aggregation is the process of collecting data and consolidating multiple values into a single value. For example, order forecast quantities are sent and stored in daily time buckets. However, the daily values can be summed and displayed in weekly, monthly, or period aggregation based on an active schedule and the displayed aggregation level.

An active schedule is defined in the Setup and Maintenance > Manage Facility Schedules task. For a time bucket generation, the quarterly type, effective from date, and effective to date are used. The period for all days is inclusive of the effective from date and the effective to date.

The displayed aggregation level determines how the data is displayed on the Manage Order Forecasts and Commits page. You can schedule aggregation by week or use a period definition. By default, forecasts are displayed aggregated by week.

The displayed aggregation level is used to calculate exceptions; for example, if displayed aggregation is set to week and day, all exceptions are calculated using weekly quantities. Exceptions are not recalculated when the displayed aggregation level is changed mid-planning cycle; for example, if you change the displayed aggregation level from week and day to period and day in the middle of a planning cycle, the exceptions that were already calculated are displayed at weekly level, even though the aggregation is displayed in months. Due to this, you may observe incorrect results.

The aggregation schedule is used to determine:

  • How forecasts are aggregated when displaying to collaboration planners and suppliers.

  • How exceptions are calculated.

Note: You need the Supply Chain Application Administrator role to configure Oracle Supply Chain Collaboration.

Default Active Schedule

In addition to the user defined active schedule, there is a system schedule called Supply Chain Collaboration Default. Supply Chain Collaboration Default is monthly quarterly type with the effective from date and effective to date set to NULL. These values indicate that the default schedule is always active and never ends.

The time buckets are generated using the Supply Chain Collaboration Default schedule when:

  • An active schedule is not selected.

  • An active schedule is selected, but is no longer active because the effective from date and effective to date range has expired.