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.

Symptoms

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)

 

 

Cause

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
Symptoms
Cause
Solution
 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
References

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