Demantra Worksheet Not Getting Refreshed To Reflect The Changed Data (Doc ID 2082531.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, LoadData

Demantra worksheet not getting refreshed to reflect the changed data

Demantra worksheet is not getting refreshed after saving data. The system is configured in such a way that as soon as data is changed in one series and saved, and worksheet refreshed, the changed data should appear in other series. The data is getting saved in the database, but when the worksheets are refreshed, the changed data is not getting pulled up in other series.
The data does appear if the worksheet is closed and then reopened.

The following error is seen in the Collaborator.log file

ERROR
-----------------------
2015-11-13 10:44:21,845 EST [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR appserver.error: ODPM-70301: Error: Cant Find Members For Filter. (Query Id: {0}, Level Id: {1})


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have many Users log in to the same worksheet.
2. Begin to make many updates to override series.
3. Refresh the worksheets and see the issue occur.


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