Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
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!