RDF: Forecast Approval Workbook Arrays Are Expanding to Enormous Sizes

(Doc ID 2197550.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Retail Demand Forecasting - Version and later
Oracle Retail Predictive Application Server - Version and later
Information in this document applies to any platform.


Forecast Approval workbooks, despite being small with 200 SKUs x 200 stores and only 104 weeks, are blowing up to enormous sizes.  This is causing performance issues as well as disk infrastructure issues.  Larger workbooks (e.g., 1000 SKUs x 200 stores x 104 weeks) albeit still small in reality, are blowing up to 20-30GBs.

This is due to the _t arrays that RPAS uses to track changes.  Those arrays are blowing up due to the change we have made to the calcmask procedure that calculates the cmtmsk##xb measure, which in turn calculates the 'approved forecast' measures.   The _t arrays for approval measures are getting marked as "every cell has changed, including historically" when the approval is performed.

Example array sizes from a production environment are as follows:



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms