R13 - Reports with Date and Timestamp type fields erroring out

(Doc ID 2418348.1)

Last updated on JULY 10, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.02.0 version, Analytics

R13- Timestamp related errors

After R13 upgrade, customer report is erroring due to the formula added on Contact Date - TIMESTAMPADD(SQL_TSI_HOUR,5,"Activity"."Due Date")

Also another report is failing on "Sales - CRM Customer Overview"."Activity"."Actual Start Date"

Logical SQL: TIMESTAMPDIFF(SQL_TSI_DAY,CAST(left(cast(filter(max("Sales - CRM Customer Overview"."Activity"."Actual Start Date")
USING "Sales - CRM Customer Overview"."Activity"."Activity Type Code" ='MEETING' and "Sales - CRM Customer Overview"."Activity"."Actual Start Date" <= CURRENT_DATE ) AS CHAR),10) AS timestamp),CURRENT_TIMESTAMP) s_13


ERROR
-----------------------
OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 59140. [nQSError: 59140] The evaluation of the index 18 expression on row count -1 failed.
Please have your System Administrator look at the log for more details on this error. (HY000)
State: HY000. Code: 46046. [nQSError: 46046] Datetime value 2018/04/13 does not match the specified format.
Please have your System Administrator look at the log for more details on this error. (HY000)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade to Rel 13.
2. Reports with Timestamp fields not working

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run reports

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms