My Oracle Support Banner

User Security Filter Cause Worksheet Failed To Load When New Created New GL Is Used (Doc ID 2424585.1)

Last updated on AUGUST 09, 2018

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Worksheet

ACTUAL BEHAVIOR
---------------
user security filter cause worksheet failed to load when New GL is used

Client is on 12.2.7 with Generic patches applied

A wrong dynamic sql was generated by Demantra Web Application.

The dynamic sql does not include 'select' clause but has 'from' and 'where' clause. Issue is happening when a GL level which does not use gl_matrix is in worksheet and user security is applied.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. GL level which does not use gl_matrix is in worksheet and user security is applied.
2. The dynamic sql does not include 'select' clause but has 'from' and 'where' clause.



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.