Fusion Applications OTBI - Analysis with Calendar function gives error [nQSError: 27045] Nonexistent column: "Time"." Report Date". (HY000) SQL Issued: SELECT "Time"." Report Date" FROM "Workforce Management - Worker Assignment Event Real Time" (Doc ID 1909747.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion HCM Cloud 11.1.8 - custom analysis
Error message when using Calendar functions in OBIEE analysis, for example:

 


According to dev team:
Currently for pushing Calendar extract function to Oracle, we use syntax TO_NUMBER(TO_CHAR()) which works .. but this syntax hit a Oracle RDBMS bug when cursor_sharing is set to FORCE.

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