Oracle Fusion AI Data Platform

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion AI Data Platform

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI Time intelligence functions does not work.

Accepted answer
11
Views
1
Comments
ACDC
ACDC Rank 3 - Community Apprentice
in Oracle Fusion AI Data Platform

We are new to Oracle, fresh implementation.

I have tried to use AGO and TODATE functions to sum up and compare ITD figures etc but somehow it errors out when i run. It feels like time levels are not recognised at all.

image.png image.png

error:

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. (HY000)

[nQSError: 43113] Message returned from OBIS. (HY000)

[nQSError: 46036] Internal Assertion: Condition levelExprPtr.get(), file server/Query/Optimizer/ServiceInterfaceMgr/Utility/Src/SQOIUMetadataConverter.cpp, line 6521. (HY000)

SQL Issued: SELECT TODATE("- Burdened Cost"."Baseline Burdened Cost In Project Currency", year) FROM "Project Control - Financial Project Plans Real Time"

OK (Ignore Error)

Tagged:

Best Answer