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

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.