Historical Data Not Updating and is Now Overstated - LY Sales Value is Not Pulling Through to MFP From Data Warehouse
(Doc ID 3045950.1)
Last updated on SEPTEMBER 06, 2024
Applies to:
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 19.0 and laterOracle Retail Assortment & Item Planning Enterprise Edition Cloud Service Plus - Version 19.0 and later
Oracle Retail Demand Forecasting Cloud Service - Version 19.0 and later
Information in this document applies to any platform.
Goal
An annual hierarchy Restructure is performed once a year and this gives the opportunity to add, move or remove the hierarchy structure. This was recently conducted over 3 days.
Following that restructure Categories have been split into different Sub-departments, however the historical data has not updated and this has now caused the LY Sales Value to be inflated.
When trying to reload the LY Sales Value from our Data Warehouse (DW), it is not pulling through to Merchandise Financial Planning (MFP).
See below example of how the History is being overstated.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |