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"
Last updated on SEPTEMBER 21, 2016
Applies to:Oracle Fusion Global Human Resources - Version 188.8.131.52.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 184.108.40.206.0 and later
Oracle Fusion Application Toolkit - Version 220.127.116.11.0 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
Million Knowledge Articles and hundreds of Community platforms