My Oracle Support Banner

OAC: Workbook Based On Excel Fails With Error 'nQSError: 59001 Subtract operation is not permitted on TIMESTAMP, INTEGER operand(s)' (Doc ID 2937490.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud - Version N/A to N/A [Release 14.1]
Information in this document applies to any platform.


Workbook based on excel data fails with the below error:

Error during query processing (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS 
State: HY000. Code: 43119. [nQSError: 43119] Query Failed:
State: HY000. Code: 59001. [nOSError: 59001] Subtract operation is not permitted on TIMESTAMP, INTEGER operand(s). (HY000) SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency',ENABLE_DIMENSIONALITY=1;SELECT O s_0,



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.