My Oracle Support Banner

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

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.