Consensus Forecast Series Not Retaining The Weighted Forecast Override Series Values In SOP (Doc ID 1944339.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.3.1.4 and later
Information in this document applies to any platform.

Symptoms

Customer is on 7314
They have a worksheet that has the following 2 seeded series in addition to other series
Weighted Forecast Override Series
Consensus Forecast
When they update the Weighted Forecast Override Series with a value they see that the Consensus Forecast gets updated to same values of Weight Forecast Override
Thereafter they save the data in the worksheet. After this when they re run the worksheet, even though the Weighted Forecast Override Series still retains the values updated, but the Consensus Forecast series goes back to its' original value

There is no error messages in the collaborator logs or Java console

This issue is reproducible with the seeded series Weighted Forecast Override Series and Consensus Forecast with no changes made to the series

The client expression in the seeded Consensus Forecast is

 

If ( Is_Modified( Weighted Forecast Override ), If ( IsNull(  Weighted Forecast Override), Weighted Forecast , Weighted Forecast Override ),  If ( Is_Modified(  Base Override  )  ,   If (  IsNull(  Base Override  )  ,   Final Forecast  ,  Base Override  )  ,  Final Forecast ))

 



Cause

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