Unable To Open Worksheet Based On Custom General Level After Setting Up User Security (Doc ID 2279966.1)

Last updated on AUGUST 18, 2017

Applies to:

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

Symptoms

Using Oracle Demantra Demand Management / Worksheet / User Security
On 12.2.5.1 through 12.2.6.2
When attempting to add User Security Filters,
the following error occurs when trying to open a worksheet 
with User Security based on General (non item/location) Levels

ERROR
-----------------------
Error: Worksheet data can't be shown. Please contact an administrator to
review system log files for details.

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Setup user with security filters

User demuser1 - Select User Filters

/ Constraint / Optimization Channel

Values:
Code Description Access
2    RTL         Full Control
3    ASP         Full Control

/ Constraint / Optimization Region
 
Values:
Code Description Access
2    AMERICAS    Full Control

 
2. Login to Demantra and open a worksheet 

Error: Worksheet data can't be shown. Please contact an administrator to
review system log files for details.

3. Below is the error in the Collaborator log –

The issue is that,
when user security is setup for the user,
the dynamic query to build the T_COMB
is erroneously joining with mdp_matrix in the where clause,
but mdp_matrix is not included in the from clause.

In this example,

Optimization Channel – is an alias level for ‘Channel’
Optimization Region – is an alias level for ‘Region’

These are parent levels to the ‘Constraint’ level,
which is a custom general level without population (like Settlement level)

The alias levels are setup similar to “Invoice Bill To” level in Demantra. The group table comparison is attached in the SR.

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