Handling 5-4-4 Fiscal Calendar in Predictive Cash Forecasting (PCF) with Daily Granularity

Summary:

How to handle 5-4-4 spread with months having 35, 28 days in Predictive Cash forecasting

Content (please ensure you mask any confidential information):

We are evaluating Oracle Predictive Cash Forecasting for a client using a 5-4-4 fiscal calendar (35/28/28or35 days), where period boundaries shift each year.

Since PCF supports only standard calendar months, this creates challenges in:

• Aggregation
• More importantly, aligning daily data to shifting fiscal periods

We explored creating an alternate hierarchy for 5-4-4 aggregation, but this doesn’t address changing month start/end dates year over year. We also considered alias tables for each year to have different start date as alias for each year.