ODPM-10074 you do not have proper rights to see the member after Data clean up script run (Doc ID 2222389.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

Customer is on version 12.2.5.1 with all the required mandatory patches

The clean up scripts were run. Thereafter when opening and running worksheets users get error
ODPM-10074 you do not have proper rights to see the member

If the user follows the workaround as described in note 1060852.1
Clear the filter, apply new filter and run it runs. Save the report and re-open again. It is reporting the same issue

They cannot apply the  Patch 9242452 mentioned in that doc since customer is already on higher version than mentioned in the document. R12.2.5.1



ERROR
----------------------
ODPM-10074 you do not have proper rights to see the member




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Run the clean up scripts
2) Run the worksheet, it shows the error
3) Clear the filter, apply new filter and run it runs. Save the report and re-open again. It is reporting the same issue

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot open and work the worksheets

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