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 FEBRUARY 25, 2019

Applies to:

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


On : 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.

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(
at oracle.jdbc.driver.DatabaseError.newSQLException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.