My Oracle Support Banner

FRS Report Update/Create Error After 19A: Essbase Error(1260052): Syntax error in input MDX query on line 2 at token '['] (Doc ID 2540024.1)

Last updated on MARCH 12, 2021

Applies to:

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


On : version, Financial Reporting and Analysis

When attempting to run a recently modified report from My Folder/Temp, the following error occurs.

Error executing query: Error: Internal Essbase JAPI error [Cannot performs cube view operation. Essbase Error(1260052): Syntax error in input MDX query on line 2 at token '[']

The issue can be reproduced at will with the following steps:
1. Copy the FRS report from a shared folder to "My Folder" using the Copy Paste feature
2. Open the report from My Folder/Temp and the report renders the data properly (same as it works from shared folders)
3. Modified the report just for a heading and saved.
4. Ran the report after entering the parameters and the attached error message is shown, no matter what the change is.

The issue has the following business impact:
Due to this issue, users cannot modify any report needed for Executive meeting and month closing




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.