PCF Period dimension members do not align to client's fiscal calendar days
Summary:
PCF Period dimension members do not align to client's fiscal calendar days
Content (please ensure you mask any confidential information):
Oracle Predictive Cash Forecasting application provides members of the Period dimensions that do not align to client's fiscal calendar days. For example client's FY25 Day1 = 2/2/2024 (Fiscal Year: Feb to Jan). Similarly client's FY27 Day 1 = 1/31/2026.
Oracle PCF's Period dimension has seeded members that do not align to the fiscal days above. For instance the Day 1 rolls up to Feb by default but Day can be in January like in the FY27 example above.
Since each year, the fiscal start date and end date will change, how can the out of the box Period dimensions setup be used? Considered the option of changing aliases or creating alias tables, but that would be an annual update and not the most efficient workaround.