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 and later
Oracle Fusion Application Toolkit Cloud Service - Version and later
Oracle Fusion Application Toolkit - Version and later
Information in this document applies to any platform.


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.


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