Past Due Forecast Bucket Purge & Consumption

Hey All,

We currently forecast in weekly buckets (about to switch to monthly buckets in January). We perform our forecast consumption on EBS side with 30 backward/30 forward days window and 50% consumption outlier.

We consume forecast sets with 'Sales Order from Start Date Forward' parameter and look backward for orders in the past 1 full year from system date.

At the same time, our customized process deletes (purges) old forecast records on a monthly basis that are older than the current month.

Our team just realized that this is problematic process because orders that were due in the past (and have already shipped out) consume our actual current forecast buckets.