ORA-00918: column ambiguously defined in Worksheets when both Intermittent Flag For IO Series And Forecast System Status Level Are Used (Doc ID 2177416.1)

Last updated on MARCH 08, 2017

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

When attempting to to open an worksheet that has both ‘Good for forecast’ level and ‘Intermittent flag for IO’ series,
the following error occurs.

ERROR
-----------------------
Page loading was canceled.

In collaborator.log file , bellow error occurs:

[Query_Execution_3] ERROR appserver.thread:
java.sql.SQLException: ORA-00918: column ambiguously defined

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Collaborator Workbench.
2. Create an worksheet that has both ‘Good for forecast’ level and ‘Intermittent flag for IO’ series.
3. Run the worksheet.
4. The worksheet fails to return data.


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