Issues With Enable Extra Filters In Worksheet

(Doc ID 1551930.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Demantra Demand Management - Version to [Release 7.3.0]
Information in this document applies to any platform.


On : version, Worksheet

When using "Enable Extra Filters" it is causing the worksheet to error out for users accessing the worksheet.

The following error occurs.

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

The issue can be reproduced at will with the following steps:
1. Define User Security for an End User to have access to one Division in the location hierarchy.
2. Setup the worksheet and check "Enable Extra Filters".
3. End User with the Security setup logs in and in the Extra Filters window, chooses a member within the Division that they have access.
4. Worksheet does not load and the error is received.

-- These End Users have User Security features enabled in the Business Modeler.
-- With "Enable Extra Filters" turned off, worksheet loads just fine and the End User can access the data.
-- End Users without User Security setups do not experience this error.

The issue has the following business impact:
Cannot use the Enable Extra Filters functionality with End Users that have User Security features setup in the BM


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