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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

OTBI date function is not working

Summary:

This filter in OTBI report is stopped working from last two weeks

" Enrollment Results"."Election Date" BETWEEN timestampadd(SQL_TSI_DAY,-7,CURRENT_DATE) AND CURRENT_DATE)

Showing below error

Content (please ensure you mask any confidential information):

Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

Location: saw.views.evc.activate

Error during query processing (SQLExecDirectW).

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

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

State: HY000. Code: 27002. [nQSError: 27002] Near <)>: Syntax error (HY000)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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