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) |
Tagged:
0