Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Error when using TODATE(REVENUE, YEAR) Oracle SQL function — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error when using TODATE(REVENUE, YEAR) Oracle SQL function

Accepted answer
edited Mar 9, 2020 1:38PM in General Transactional Reporting (OTBI) 7 comments


TODATE function resulted in error, what are possible alternatives to get the needed results?


Hello Oracle Community,

The below error (per enclosed 2 screenshots) prompted when using TODATE function (per enclosed screenshot named TD) in Analysis in Oracle BI.  "Total Revenue" is a fact component:

Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27037] Unresolved level: "year". (HY000)
SQL Issued: SELECT TODATE("Costing - COGS and Gross Margin Real Time"."Revenue"."Total Revenue", year) FROM "Distributed Order Orchestration - Fulfillment Lines Real Time"

1) What is the cause to this error?  What would be the resolution to this error?


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!