Error Loading Worksheet After Canceling Worksheet “Extra Filter” Prompt (Doc ID 2158761.1)

Last updated on JULY 07, 2016

Applies to:

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

Symptoms

If you enable extra filter in the worksheet and click on “cancel” on extra filter form, you will not be able to re-run worksheet or run any other extra filter.
You have to close the worksheet and re-open it again to recover from this error.
 

ERROR
ODPM-10057: Object is not valid" ODPM-00064: Missing Members for Worksheet
Context, and therefore, can not create Worksheet Context object.


STEPS TO REPRODUCE
1. Worksheet setup: Enable Extra Filter is checked
2. Layout: The default tab has 3 levels
3. Run the worksheet
4. Extra Filters Pop-up window show up correctly
5. Select a level member and click on finish
6. Worksheet will open and will be filtered for that level member only
7. Now, change extra filter: View drop down menu -> Change extra Filters
8. The extra filter window prompts again
9. Click on “Cancel” and the window disappears
10. Now try to re-run the worksheet and the following error will pop-up:

ODPM-10057: Object is not valid" ODPM-00064: Missing Members for Worksheet
Context, and therefore, can not create Worksheet Context object.

11. Click OK through the message.
12. Try to change extra filter and the View drop down menu also will not expand.
13. The only way to recover from this is to close the whole worksheet window and reopen it again.


BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, you have to close and re-open the worksheet every time

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