Worksheet Notes Are Not Displayed At Aggregated Level

(Doc ID 2344529.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

On : 12.2.5.1 version, Worksheet

ACTUAL BEHAVIOR
---------------
Worksheet Notes are not displayed at aggregated level

We are able to view the worksheet notes at the lowest level. But, when user tries to view the same note at an aggregated level they are not getting that note. we can see the note icon present at the aggregated level.

When we checked the collaborator.log, we found following error message.

=============================================
2017-11-17 12:01:25,859 EST [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR appserver.error:
java.sql.SQLSyntaxErrorException: ORA-00904: "MDP_MATRIX"."LOCATION_ID": invalid identifier

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:762)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1309)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:422)
at weblogic.jdbc.wrapper.Statement.executeQuery(Statement.java:511)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at com.demantra.applicationServer.services.NotesDBHandler.getNotesFromDB(NotesDBHandler.java:1078)


EXPECTED BEHAVIOR
-----------------------
should show notes at higher aggregated level

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create notes at lower level in worsheet
2. change aggregation to higher level
3. open notes in higher level

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
unable to see lower level created notes at higher level

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