My Oracle Support Banner

OTAC/TEE: Error: "Formula syntax is invalid." (Doc ID 2439859.1)

Last updated on SEPTEMBER 17, 2021

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 20D and later
Information in this document applies to any platform.


Error Description:

After creating a new formula or modifying an existing formula through Selected Columns > Edit Formula in OBI, upon selecting OK, the following message is returned:

Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27002] Near : Syntax error (HY000)




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
 The Formula is Missing Right or Left Parentheses or Contains an Extra Right or Left Parentheses
 The Formula Contains a Field Name That is Invalid or Mistyped
 The Formula Contains a CASE WHEN Statement That is Missing an End Clause or The Formula Contains an Extra or Stray END Clause
 Formula Contains an IN Clause with Incorrect Delimiters
 Formula Contains a BY Clause That is in the Wrong Place
 Formula Contains a CASE BY CHAR or VARCHAR Without Specifying the Number of Characters

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